| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
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 |
