Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_SCHEDULER_CHAINS

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

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