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