Use EVERYDAY_WINDOW for DEFAULT_MAINTENANCE_PLAN:
BEGIN
-- Create a new window called EVERYDAY_WINDOW
DBMS_SCHEDULER.CREATE_WINDOW(
window_name=>'"EVERYDAY_WINDOW"',
resource_plan=>'DEFAULT_MAINTENANCE_PLAN',
start_date=>systimestamp at time zone 'Asia/Taipei',
duration=>numtodsinterval(180, 'minute'),
repeat_interval=>'FREQ=WEEKLY;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN;BYHOUR=6;BYMINUT
E=30;BYSECOND=0',
end_date=>null,
window_priority=>'LOW',
comments=>'Everyday');
-- Add EVERYDAY_WINDOW to the default MAINTENANCE_WINDOW_GROUP
DBMS_SCHEDULER.ADD_WINDOW_GROUP_MEMBER(
group_name=>'"MAINTENANCE_WINDOW_GROUP"',
window_list=>'"EVERYDAY_WINDOW"');
-- Remove Original WINDOWs from MAINTENANCE_WINDOW_GROUP
DBMS_SCHEDULER.REMOVE_WINDOW_GROUP_MEMBER(
group_name=>'"MAINTENANCE_WINDOW_GROUP"',
window_list=>'"FRIDAY_WINDOW","SATURDAY_WINDOW","SUNDAY_WINDOW","MONDAY_WINDOW",
"TUESDAY_WINDOW","WEDNESDAY_WINDOW","THURSDAY_WINDOW"');
-- Disable Original WINDOWs
DBMS_SCHEDULER.DISABLE(name => 'FRIDAY_WINDOW');
DBMS_SCHEDULER.DISABLE(name => 'SATURDAY_WINDOW');
DBMS_SCHEDULER.DISABLE(name => 'SUNDAY_WINDOW');
DBMS_SCHEDULER.DISABLE(name => 'MONDAY_WINDOW');
DBMS_SCHEDULER.DISABLE(name => 'TUESDAY_WINDOW');
DBMS_SCHEDULER.DISABLE(name => 'WEDNESDAY_WINDOW');
DBMS_SCHEDULER.DISABLE(name => 'THURSDAY_WINDOW');
END;
/
Check Whether The Scheduled Maintenance Plan Was Successfully Executed By:
SQL> select * from dba_autotask_job_history order by job_start_time;
