ALL_SCHEDULER_CHAIN_RULES shows the rules of all the chains visible to the current user (that is, those chains that the user has ALTER or EXECUTE privileges for).
DBA_SCHEDULER_CHAIN_RULES shows all rules for all chains.
USER_SCHEDULER_CHAIN_RULES shows the rules for 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 |
Chain schema |
CHAIN_NAME |
VARCHAR2(30) |
NOT NULL |
Chain name |
RULE_OWNER |
VARCHAR2(30) |
NOT NULL |
Rule schema |
RULE_NAME |
VARCHAR2(30) |
Rule name | |
CONDITION |
VARCHAR2(4000) |
Rule condition | |
ACTION |
VARCHAR2(4000) |
Rule action | |
COMMENTS |
VARCHAR2(4000) |
User comments for the rule |