ALL_SCHEDULER_CHAIN_RULES

Previous Next JavaScript must be enabled to correctly display this content

3.35 ALL_SCHEDULER_CHAIN_RULES

ALL_SCHEDULER_CHAIN_RULES displays information about the rules for the chains accessible to the current user (that is, those chains that the user has ALTER or EXECUTE privileges for).

Related Views

DBA_SCHEDULER_CHAIN_RULES displays information about the rules for all chains in the database.
USER_SCHEDULER_CHAIN_RULES displays information about the rules for the chains owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the Scheduler chain that the rule is in
`CHAIN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the Scheduler chain that the rule is in
`RULE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the rule
`RULE_NAME`	`VARCHAR2(128)`		Name of the rule
`CONDITION`	`VARCHAR2(4000)`		Boolean condition triggering the rule
`ACTION`	`VARCHAR2(4000)`		Action to be performed when the rule is triggered
`COMMENTS`	`VARCHAR2(4000)`		User-specified comments about the rule

See Also: