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).
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 |
VARCHAR2(30) |
NOT NULL |
Owner of the Scheduler chain |
CHAIN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the Scheduler chain |
RULE_SET_OWNER |
VARCHAR2(30) |
Owner of the rule set describing the dependencies | |
RULE_SET_NAME |
VARCHAR2(30) |
Name of the rule set describing the dependencies | |
NUMBER_OF_RULES |
NUMBER |
Number of rules in the chain | |
NUMBER_OF_STEPS |
NUMBER |
Number of defined steps in the chain | |
ENABLED |
VARCHAR2(5) |
Indicates whether the chain is enabled (TRUE) or disabled (FALSE) |
|
EVALUATION_INTERVAL |
INTERVAL DAY(3) TO SECOND(0) |
Periodic interval at which to reevaluate rules for the chain | |
USER_RULE_SET |
VARCHAR2(5) |
Indicates whether the chain uses a user-specified rule set (TRUE) or not (FALSE) |
|
COMMENTS |
VARCHAR2(240) |
Comments on the chain |