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 of the Scheduler program |
|
|
|
Name of the Scheduler program |
|
|
Type of the program action:
|
|
|
|
String specifying the program action |
|
|
|
Number of arguments accepted by the program |
|
|
|
Indicates whether the program is enabled ( |
|
|
|
This column is for internal use |
|
|
|
Maximum delay in running the program after the scheduled start |
|
|
|
Priority of the program |
|
|
|
Weight of the program |
|
|
|
Maximum number of runs of any job based on this program |
|
|
|
Maximum number of failures of any job based on this program |
|
|
|
Maximum amount of time this program can run |
|
|
|
NLS environment in which the program was created |
|
|
|
Comments on the program |
See Also: