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).
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(30) |
NOT NULL |
Owner of the Scheduler chain that the rule is in |
CHAIN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the Scheduler chain that the rule is in |
RULE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the rule |
RULE_NAME |
VARCHAR2(30) |
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 |