Updated on 2024-05-07 GMT+08:00

DB_SCHEDULER_JOB_ARGS

DB_SCHEDULER_JOB_ARG displays the parameters related to the tasks accessible to the current user. This view is accessible to all users and displays all information accessible to the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_SCHEDULER_JOB_ARGS columns

Name

Type

Description

owner

character varying(128)

Owner of the job to which the parameter belongs.

job_name

character varying(128)

Name of the job 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 a user-defined data type.

value

character varying(4000)

Parameter value.

anydata_value

character varying(4000)

Not supported. Its value is NULL.

out_argument

character varying(5)

Reserved column. Its value is NULL.