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

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


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