ALL_SCHEDULER_CHAINS shows all chains visible to the current user (that is, those chains that the user has ALTER or EXECTUE privileges for).
DBA_SCHEDULER_CHAINS shows all chains in the database.
USER_SCHEDULER_CHAINS shows all chains in the current user's schema. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owning schema |
CHAIN_NAME |
VARCHAR2(30) |
NOT NULL |
Unique user-specified name |
RULE_SET_OWNER |
VARCHAR2(30) |
Owning schema 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 steps in the chain | |
ENABLED |
VARCHAR2(5) |
Whether or not the chain is enabled | |
EVALUATION_INTERVAL |
INTERVAL DAY(3) TO SECOND(0) |
Periodic interval at which to evaluate rules for this chain | |
USER_RULE_SET |
VARCHAR2(5) |
Whether or not the chain has a user-specified rule set | |
COMMENTS |
VARCHAR2(240) |
User comments |