[Home] [Help] [Dependency Information]
Object Name: | DBA_SCHEDULER_CHAIN_RULES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All rules from scheduler chains in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the scheduler chain the rule is in |
CHAIN_NAME | VARCHAR2 | (128) | Yes | Name of the scheduler chain the rule is in |
RULE_OWNER | VARCHAR2 | (128) | Yes | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, CHAIN_NAME
, RULE_OWNER
, RULE_NAME
, CONDITION
, ACTION
, COMMENTS
FROM SYS.DBA_SCHEDULER_CHAIN_RULES;
|
|
|