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

VIEW: SYS.DBA_SCHEDULER_WINDOWS

Object Details
Object Name: DBA_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.DBA_SCHEDULER_WINDOWS;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_WINDOWS references the following:

SchemaSYS
TableOBJ$
TableSCHEDULER$_WINDOW
TableUSER$
SYS.DBA_SCHEDULER_WINDOWS is referenced by following:

SchemaPUBLIC
SynonymDBA_SCHEDULER_WINDOWS
SchemaSYS
ViewALL_SCHEDULER_WINDOWS
ViewDBA_AUTOTASK_SCHEDULE
ViewDBA_AUTOTASK_TASK
ViewDBA_AUTOTASK_WINDOW_CLIENTS
ViewDBA_AUTOTASK_WINDOW_HISTORY
PL/SQL PackageDBMS_AUTO_TASK - show dependent code
Package BodyDBMS_AUTO_TASK_EXPORT - show dependent code
ProcedureDBMS_FEATURE_JOB_SCHEDULER - show dependent code
Package BodyDBMS_SPACE - show dependent code
Package BodyPRVT_ILM - show dependent code