ALL_SCHEDULER_PROGRAMS
displays information about the Scheduler programs accessible to the current user.
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 |