Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
ALL_SCHEDULER_CHAINS
shows all chains visible to the current user (that is, those chains that the user has ALTER or EXECTUE privileges for).
Related Views
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 |