4.56 ALL_SCHEDULER_PROGRAM_ARGS

ALL_SCHEDULER_PROGRAM_ARGS displays information about the arguments of the Scheduler programs accessible to the current user.

Related Views

  • DBA_SCHEDULER_PROGRAM_ARGS displays information about the arguments of all Scheduler programs in the database.

  • USER_SCHEDULER_PROGRAM_ARGS displays information about the arguments of the Scheduler programs owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the program to which the argument belongs

PROGRAM_NAME

VARCHAR2(128)

NOT NULL

Name of the program to which the argument belongs

ARGUMENT_NAME

VARCHAR2(128)

Optional name of the argument

ARGUMENT_POSITION

NUMBER

NOT NULL

Position of the argument in the argument list

ARGUMENT_TYPE

VARCHAR2(257)

Data type of the argument

METADATA_ATTRIBUTE

VARCHAR2(19)

Metadata attribute:

  • JOB_NAME

  • JOB_OWNER

  • JOB_START

  • WINDOW_START

  • WINDOW_END

  • JOB_SUBNAME

  • EVENT_MESSAGE

  • JOB_SCHEDULED_START

DEFAULT_VALUE

VARCHAR2(4000)

Default value taken by the argument (in string format) if the argument is a string

DEFAULT_ANYDATA_VALUE

ANYDATA

Default value taken by the argument (in AnyData format)

OUT_ARGUMENT

VARCHAR2(5)

Reserved for future use

See Also: