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:



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