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


VIEW: SYS.DBA_AUTOTASK_SCHEDULE

Object Details
Object Name: DBA_AUTOTASK_SCHEDULE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Schedule of Maintenance Windows for the next 32 days

[View Source]

Columns
Name Datatype Length Mandatory Comments
WINDOW_NAME VARCHAR2 (128)
Name of the Maintenance Window
START_TIME TIMESTAMP(6) WITH TIME ZONE (13)
Projected start time of the window
DURATION INTERVAL DAY(3) TO SECOND(0) (11)
Currently defined duration of the window
Query Text

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


SELECT WINDOW_NAME
,      START_TIME
,      DURATION
FROM SYS.DBA_AUTOTASK_SCHEDULE;

Dependencies

[top of page]

SYS.DBA_AUTOTASK_SCHEDULE references the following:

SchemaSYS
ViewDBA_SCHEDULER_WINDOWS
ViewDBA_SCHEDULER_WINGROUP_MEMBERS
PL/SQL PackageDBMS_AUTO_TASK - show dependent code
TYPESYS_PLSQL_1594E20B_37_1
SYS.DBA_AUTOTASK_SCHEDULE is referenced by following:

SchemaPUBLIC
SynonymDBA_AUTOTASK_SCHEDULE