[bbk5167]第58集-第6章 - 用scheduler自动化 06

Creating Complex Schedules

/*
        ==================================================================================
        Creating Complex Schedules
        ==================================================================================
*/

BEGIN
        DBMS_SCHEDULER.CREATE_SCHEDULE(
                'NYDay',
                repeat_interval         => 'FREQ=MONTHLY;BYMONTH=JAN;BYMONTHDAY=1'
        );
END;
/

BEGIN
        DBMS_SCHEDULER.CREATE_SCHEDULE(
                'MEMDay',
                repeat_interval         => 'FREQ=MONTHLY;BYMONTH=MAY;BYDAY =1MON'
        );
END;
/

BEGIN
        DBMS_SCHEDULER.CREATE_SCHEDULE(
                'InDay',
                repeat_interval         => 'FREQ=MONTHLY;BYMONTH=JUL;BYMONTHDAY=4'
        );
END;
/

BEGIN
        DBMS_SCHEDULER.CREATE_SCHEDULE(
                'Comp_Holidays',
                repeat_interval         => 'FREQ=MONTHLY;INCLUDE=NYDay,MEMDay,InDay'
        );
END;
/