ALL_SCHEDULER_CHAINS
displays information about the chains accessible to the current user (that is, those chains that the user has ALTER
or EXECUTE
privileges for).
Related Views
DBA_SCHEDULER_CHAINS
displays information about all chains in the database.
USER_SCHEDULER_CHAINS
displays information about the chains owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the Scheduler chain |
|
|
|
Name of the Scheduler chain |
|
|
Owner of the rule set describing the dependencies |
|
|
|
Name of the rule set describing the dependencies |
|
|
|
Number of rules in the chain |
|
|
|
Number of defined steps in the chain |
|
|
|
Indicates whether the chain is enabled ( |
|
|
|
Periodic interval at which to reevaluate rules for the chain |
|
|
|
Indicates whether the chain uses a user-specified rule set ( |
|
|
|
Comments on the chain |
See Also: