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

weixin_30312557

于 2013-05-29 11:50:00 发布

阅读量98

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/arcer/archive/2013/05/29/3105680.html

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;
/