Updated on 2024-06-03 GMT+08:00

ADM_SCHEDULER_PROGRAM_ARGS

ADM_SCHEDULER_PROGRAM_ARG displays parameters related to all programs in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the PG_CATALOG and SYS schemas.

Table 1 ADM_SCHEDULER_PROGRAM_ARGS columns

Name

Type

Description

owner

character varying(128)

Owner of the program to which the parameter belongs.

program_name

character varying(128)

Name of the program to which the parameter belongs.

argument_name

character varying(128)

Parameter name.

argument_position

numeric

Position of the parameter in the parameter list.

argument_type

character varying(257)

Data type of a parameter, which can be user-defined.

metadata_attribute

character varying(19)

Not supported. Its value is NULL.

default_value

character varying(4000)

Default parameter value.

default_anydata_value

character varying(4000)

Not supported. Its value is NULL.

out_argument

character varying(5)

Reserved column. The value is NULL.