VIEW: SYS.DBA_AUTOTASK_SCHEDULE

Source

View Text - Preformatted

SELECT "WINDOW_NAME","START_TIME","DURATION"
    FROM TABLE (dbms_auto_task.window_calendar(
                CURSOR(SELECT wgr.window_name,
                              case when w.start_date > current_timestamp
                                   then w.start_date
                                   else current_timestamp
                              end,
                              case when w.end_date <
                                       (current_timestamp + INTERVAL '32' DAY)
                                   then w.end_date
                                   else current_timestamp + INTERVAL '32' DAY
                              end
                         FROM dba_scheduler_windows w,
                              dba_scheduler_wingroup_members wgr
                        WHERE w.window_name = wgr.window_name
                          AND w.enabled = 'TRUE'
                          AND (w.start_date IS NULL
                               OR w.start_date < current_timestamp + INTERVAL '32' DAY)
                          AND wgr.window_group_name = 'MAINTENANCE_WINDOW_GROUP')))

View Text - HTML Formatted

SELECT "WINDOW_NAME"
, "START_TIME"
, "DURATION"
FROM TABLE (DBMS_AUTO_TASK.WINDOW_CALENDAR( CURSOR(SELECT WGR.WINDOW_NAME
, CASE WHEN W.START_DATE > CURRENT_TIMESTAMP THEN W.START_DATE ELSE CURRENT_TIMESTAMP END
, CASE WHEN W.END_DATE < (CURRENT_TIMESTAMP + INTERVAL '32' DAY) THEN W.END_DATE ELSE CURRENT_TIMESTAMP + INTERVAL '32' DAY END
FROM DBA_SCHEDULER_WINDOWS W
, DBA_SCHEDULER_WINGROUP_MEMBERS WGR
WHERE W.WINDOW_NAME = WGR.WINDOW_NAME
AND W.ENABLED = 'TRUE'
AND (W.START_DATE IS NULL OR W.START_DATE < CURRENT_TIMESTAMP + INTERVAL '32' DAY)
AND WGR.WINDOW_GROUP_NAME = 'MAINTENANCE_WINDOW_GROUP')))