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.ALL_SCHEDULER_WINDOWS

Object Details

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

All scheduler windows in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the scheduler window
WINDOW_NAME	VARCHAR2	(128)	Yes	Name of the scheduler window
RESOURCE_PLAN	VARCHAR2	(128)		Resource plan associated with the window
SCHEDULE_OWNER	VARCHAR2	(4000)		Owner of the schedule of this window
SCHEDULE_NAME	VARCHAR2	(4000)		Name of the schedule of this window
SCHEDULE_TYPE	VARCHAR2	(8)		Type of the schedule of this window
START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Start date of the window (for an inlined schedule)
REPEAT_INTERVAL	VARCHAR2	(4000)		Calendar string for this window (for an inlined schedule)
END_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Date after which the window will no longer open (for an inlined schedule)
DURATION	INTERVAL DAY(3) TO SECOND(0)	(11)		Duration of the window
WINDOW_PRIORITY	VARCHAR2	(4)		Priority of this job relative to other windows
NEXT_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Next date on which this window is scheduled to start
LAST_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		The last date on which this window opened
ENABLED	VARCHAR2	(5)		True if the window is enabled
ACTIVE	VARCHAR2	(5)		True if the window is open
MANUAL_OPEN_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		Open time of window if it was manually opened, else NULL
MANUAL_DURATION	INTERVAL DAY(3) TO SECOND(0)	(11)		Duration of window if it was manually opened, else NULL
COMMENTS	VARCHAR2	(240)		Comments on the window

Query Text

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


SELECT OWNER
,      WINDOW_NAME
,      RESOURCE_PLAN
,      SCHEDULE_OWNER
,      SCHEDULE_NAME
,      SCHEDULE_TYPE
,      START_DATE
,      REPEAT_INTERVAL
,      END_DATE
,      DURATION
,      WINDOW_PRIORITY
,      NEXT_START_DATE
,      LAST_START_DATE
,      ENABLED
,      ACTIVE
,      MANUAL_OPEN_TIME
,      MANUAL_DURATION
,      COMMENTS
FROM SYS.ALL_SCHEDULER_WINDOWS;

Dependencies

[top of page]

SYS.ALL_SCHEDULER_WINDOWS references the following:

SYS: DBA_SCHEDULER_WINDOWS

SYS.ALL_SCHEDULER_WINDOWS is referenced by following:

PUBLIC: ALL_SCHEDULER_WINDOWS
SYS: DBMS_SCHED_MAIN_EXPORT - show dependent code