DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_SCHEDULER_PROGRAMS

Object Details
Object Name: ALL_SCHEDULER_PROGRAMS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All scheduler programs visible to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the scheduler program
PROGRAM_NAME VARCHAR2 (128) Yes Name of the scheduler program
PROGRAM_TYPE VARCHAR2 (16)
Type of program action
PROGRAM_ACTION VARCHAR2 (4000)
String specifying the program action
NUMBER_OF_ARGUMENTS NUMBER

Number of arguments accepted by the program
ENABLED VARCHAR2 (5)
Whether the program is enabled
DETACHED VARCHAR2 (5)
This column is for internal use
SCHEDULE_LIMIT INTERVAL DAY(3) TO SECOND(0) (11)
Maximum delay in running program after scheduled start
PRIORITY NUMBER

Priority of program
WEIGHT NUMBER

Weight of program
MAX_RUNS NUMBER

Maximum number of runs of program
MAX_FAILURES NUMBER

Maximum number of failures of program
MAX_RUN_DURATION INTERVAL DAY(3) TO SECOND(0) (11)
Maximum run duration of program
NLS_ENV VARCHAR2 (4000)
NLS Environment in which program was created
COMMENTS VARCHAR2 (240)
Comments on the program
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      PROGRAM_NAME
,      PROGRAM_TYPE
,      PROGRAM_ACTION
,      NUMBER_OF_ARGUMENTS
,      ENABLED
,      DETACHED
,      SCHEDULE_LIMIT
,      PRIORITY
,      WEIGHT
,      MAX_RUNS
,      MAX_FAILURES
,      MAX_RUN_DURATION
,      NLS_ENV
,      COMMENTS
FROM SYS.ALL_SCHEDULER_PROGRAMS;

Dependencies

[top of page]

SYS.ALL_SCHEDULER_PROGRAMS references the following:

SchemaSYS
TableOBJ$
TableOBJAUTH$
TableSCHEDULER$_PROGRAM
TableUSER$
SYS.ALL_SCHEDULER_PROGRAMS is referenced by following:

SchemaPUBLIC
SynonymALL_SCHEDULER_PROGRAMS
SchemaSYS
Package BodyDBMS_APPLY_ADM_INTERNAL - show dependent code
ProcedureDBMS_FEATURE_JOB_SCHEDULER - show dependent code