DanBrother的部落格

By Default  each day scheduler is set at 10:00PM.
It can be modified by the following PL/SQL (take MONDAY_WINDOW as an example):

-- reset the scheduler to 3:00AM

BEGIN
DBMS_SCHEDULER.DISABLE(name=>'"SYS"."MONDAY_WINDOW"',force=>TRUE);

DBMS_SCHEDULER.SET_ATTRIBUTE(name=>'"SYS"."MONDAY_WINDOW"',
                             attribute=>'REPEAT_INTERVAL',
                             value=>'FREQ=WEEKLY;BYDAY=MON;BYHOUR=3;BYMINUTE=0;B
YSECOND=0');

DBMS_SCHEDULER.ENABLE(name=>'"SYS"."MONDAY_WINDOW"');
END;
/