eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_SCHEDULER_CHAINS

Object Details

Object Name:	DBA_SCHEDULER_CHAINS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All scheduler chains in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the scheduler chain
CHAIN_NAME	VARCHAR2	(128)	Yes	Name of the scheduler chain
RULE_SET_OWNER	VARCHAR2	(128)		Owner of the associated rule set
RULE_SET_NAME	VARCHAR2	(128)		Name of the associated rule set
NUMBER_OF_RULES	NUMBER			Number of rules in this chain
NUMBER_OF_STEPS	NUMBER			Number of defined steps in this chain
ENABLED	VARCHAR2	(5)		Whether the chain is enabled
EVALUATION_INTERVAL	INTERVAL DAY(3) TO SECOND(0)	(11)		Periodic interval at which to reevaluate rules for this chain
USER_RULE_SET	VARCHAR2	(5)		Whether the chain uses a user-specified rule set
COMMENTS	VARCHAR2	(240)		Comments on the chain

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      CHAIN_NAME
,      RULE_SET_OWNER
,      RULE_SET_NAME
,      NUMBER_OF_RULES
,      NUMBER_OF_STEPS
,      ENABLED
,      EVALUATION_INTERVAL
,      USER_RULE_SET
,      COMMENTS
FROM SYS.DBA_SCHEDULER_CHAINS;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_CHAINS references the following:

SYS: OBJ$; RULE_MAP$; SCHEDULER$_CHAIN; SCHEDULER$_STEP; USER$

SYS.DBA_SCHEDULER_CHAINS is referenced by following:

PUBLIC: DBA_SCHEDULER_CHAINS
SYS: DBMS_FEATURE_JOB_SCHEDULER - show dependent code