← Scheduler & Jobs
Oracle · Scheduler & Jobs

How to check Scheduler maintenance windows in Oracle

List Scheduler maintenance windows, their resource plan, next start, duration, priority, and which window is currently active.

Tested on11g12c18c19c21c23ai26ai

List Scheduler maintenance windows, their resource plan, next start, duration, priority, and which window is currently active.

SELECT window_name, resource_plan, enabled, active,
       TO_CHAR(next_start_date,'YYYY-MM-DD HH24:MI') AS next_start,
       duration, window_priority, repeat_interval
FROM   dba_scheduler_windows
ORDER  BY active DESC, next_start_date;
DBMS_SCHEDULERSchedulerWindowsMaintenance