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_SCHEDULES

Object Details

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

All schedules in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the schedule
SCHEDULE_NAME	VARCHAR2	(128)	Yes	Name of the schedule
SCHEDULE_TYPE	VARCHAR2	(12)		Type of the schedule
START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Start date for the repeat interval
REPEAT_INTERVAL	VARCHAR2	(4000)		Calendar syntax expression for this schedule
EVENT_QUEUE_OWNER	VARCHAR2	(128)		Owner of source queue into which event will be raised
EVENT_QUEUE_NAME	VARCHAR2	(128)		Name of source queue into which event will be raised
EVENT_QUEUE_AGENT	VARCHAR2	(128)		Name of AQ agent used by user on the event source queue (if it is a secure queue)
EVENT_CONDITION	VARCHAR2	(4000)		Boolean expression used as subscription rule for event on the source queue
FILE_WATCHER_OWNER	VARCHAR2	(261)		Owner of file watcher on which this schedule is based
FILE_WATCHER_NAME	VARCHAR2	(261)		Name of file watcher on which this schedule is based
END_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Cutoff date after which the schedule will not specify any dates
COMMENTS	VARCHAR2	(240)		Comments on this schedule

Query Text

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


SELECT OWNER
,      SCHEDULE_NAME
,      SCHEDULE_TYPE
,      START_DATE
,      REPEAT_INTERVAL
,      EVENT_QUEUE_OWNER
,      EVENT_QUEUE_NAME
,      EVENT_QUEUE_AGENT
,      EVENT_CONDITION
,      FILE_WATCHER_OWNER
,      FILE_WATCHER_NAME
,      END_DATE
,      COMMENTS
FROM SYS.DBA_SCHEDULER_SCHEDULES;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_SCHEDULES references the following:

SYS: OBJ$; SCHEDULER$_SCHEDULE; USER$

SYS.DBA_SCHEDULER_SCHEDULES is referenced by following:

PUBLIC: DBA_SCHEDULER_SCHEDULES
SYS: ALL_SCHEDULER_SCHEDULES; DBMS_FEATURE_JOB_SCHEDULER - show dependent code; DBMS_STREAMS_SM - show dependent code