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:

• "DBA_SCHEDULER_CHAIN_RULES"

• "USER_SCHEDULER_CHAIN_RULES"