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(30) NOT NULL Owner of the program to which the argument belongs
PROGRAM_NAME VARCHAR2(30) NOT NULL Name of the program to which the argument belongs
ARGUMENT_NAME VARCHAR2(30)   Optional name of the argument
ARGUMENT_POSITION NUMBER NOT NULL Position of the argument in the argument list
ARGUMENT_TYPE VARCHAR2(61)   Datatype 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: