ALL_SCHEDULER_PROGRAMS

ALL_SCHEDULER_PROGRAMS displays information about the Scheduler programs accessible to the current user.

Related Views

DBA_SCHEDULER_PROGRAMS displays information about all Scheduler programs in the database.
USER_SCHEDULER_PROGRAMS displays information about 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 Scheduler program
`PROGRAM_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the Scheduler program
`PROGRAM_TYPE`	`VARCHAR2(16)`		Program action type: `PLSQL_BLOCK` `STORED_PROCEDURE` `EXECUTABLE`
`PROGRAM_ACTION`	`VARCHAR2(4000)`		Program action
`NUMBER_OF_ARGUMENTS`	`NUMBER`		Number of arguments accepted by the program
`ENABLED`	`VARCHAR2(5)`		Indicates whether the program is enabled (`TRUE`) or not (`FALSE`)
`DETACHED`	`VARCHAR2(5)`		This column is for internal use
`COMMENTS`	`VARCHAR2(240)`		Comments on the program