Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_SCHEDULER_PROGRAMS

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

Related Views

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)   Type of the program action:
  • PLSQL_BLOCK

  • STORED_PROCEDURE

  • EXECUTABLE

PROGRAM_ACTION VARCHAR2(4000)   String specifying the program action
NUMBER_OF_ARGUMENTS NUMBER   Number of arguments accepted by the program
ENABLED VARCHAR2(5)   Indicates whether the program is enabled (TRUE) or disabled (FALSE)
DETACHED VARCHAR2(5)   This column is for internal use
SCHEDULE_LIMIT INTERVAL DAY(3) TO SECOND(0)   Maximum delay in running the program after the scheduled start
PRIORITY NUMBER   Priority of the program
WEIGHT NUMBER   Weight of the program
MAX_RUNS NUMBER   Maximum number of runs of any job based on this program
MAX_FAILURES NUMBER   Maximum number of failures of any job based on this program
MAX_RUN_DURATION INTERVAL DAY(3) TO SECOND(0)   Maximum amount of time this program can run
NLS_ENV VARCHAR2(4000)   NLS environment in which the program was created
COMMENTS VARCHAR2(240)   Comments on the program