begin
sys.dbms_scheduler.set_attribute(name
=> 'SYS.MONDAY_WINDOW', attribute =>
'repeat_interval', value =>
'freq=daily;byday=MON;byhour=2;byminute=0; bysecond=0');
sys.dbms_scheduler.set_attribute(name
=> 'SYS.MONDAY_WINDOW', attribute =>
'duration', value => '0 04:00:00');
end;
/
begin
sys.dbms_scheduler.set_attribute(name
=> 'SYS.TUESDAY_WINDOW', attribute =>
'repeat_interval', value =>
'freq=daily;byday=TUE;byhour=2;byminute=0; bysecond=0');
sys.dbms_scheduler.set_attribute(name
=> 'SYS.TUESDAY_WINDOW', attribute =>
'duration', value => '0 04:00:00');
end;
/
begin
sys.dbms_scheduler.set_attribute(name
=> 'SYS.WEDNESDAY_WINDOW', attribute
=> 'repeat_interval', value =>
'freq=daily;byday=WED;byhour=2;byminute=0; bysecond=0');
sys.dbms_scheduler.set_attribute(name
=> 'SYS.WEDNESDAY_WINDOW', attribute
=> 'duration', value => '0
04:00:00');
end;
/
begin
sys.dbms_scheduler.set_attribute(name
=> 'SYS.THURSDAY_WINDOW', attribute
=> 'repeat_interval', value =>
'freq=daily;byday=THU;byhour=2;byminute=0; bysecond=0');
sys.dbms_scheduler.set_attribute(name
=> 'SYS.THURSDAY_WINDOW', attribute
=> 'duration', value => '0
04:00:00');
end;
/
begin
sys.dbms_scheduler.set_attribute(name
=> 'SYS.FRIDAY_WINDOW', attribute =>
'repeat_interval', value =>
'freq=daily;byday=FRI;byhour=2;byminute=0; bysecond=0');
sys.dbms_scheduler.set_attribute(name
=> 'SYS.FRIDAY_WINDOW', attribute =>
'duration', value => '0 04:00:00');
end;
/
begin
sys.dbms_scheduler.set_attribute(name
=> 'SYS.SATURDAY_WINDOW', attribute
=> 'repeat_interval', value =>
'freq=daily;byday=SAT;byhour=2;byminute=0; bysecond=0');
sys.dbms_scheduler.set_attribute(name
=> 'SYS.SATURDAY_WINDOW', attribute
=> 'duration', value => '0
08:00:00');
end;
/
begin
sys.dbms_scheduler.set_attribute(name
=> 'SYS.SUNDAY_WINDOW', attribute =>
'repeat_interval', value =>
'freq=daily;byday=SUN;byhour=2;byminute=0; bysecond=0');
sys.dbms_scheduler.set_attribute(name
=> 'SYS.SUNDAY_WINDOW', attribute =>
'duration', value => '0 08:00:00');
end;
/