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

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