oracle 创建scheduler,job

最新推荐文章于 2021-04-11 06:50:15 发布

rudy_gao

最新推荐文章于 2021-04-11 06:50:15 发布

阅读量1.2k

点赞数

分类专栏： oracle_resource job_resource

本文链接：https://blog.csdn.net/rudygao/article/details/26263131

版权

oracle_resource 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

job_resource

3 篇文章 0 订阅

订阅专栏

1. 创建要调用的存储过程

CREATE OR REPLACE PROCEDURE INESRT_SCHEDULER_USER IS
BEGIN
  INSERT INTO SCHEDULER_USER
    (ID, USERNAME, PASSWORD)
  VALUES
    (RUDY_SEQ.NEXTVAL,
     'rudy' || RUDY_SEQ.CURRVAL,
     'password' || RUDY_SEQ.CURRVAL);
  COMMIT;
END INESRT_SCHEDULER_USER;

2.创建program

DBMS_SCHEDULER.CREATE_PROGRAM(PROGRAM_NAME   => 'rudy_program',
                                PROGRAM_TYPE   => 'STORED_PROCEDURE',
                                PROGRAM_ACTION => 'inesrt_scheduler_user',
                                ENABLED        => TRUE);

3.创建schedule

  DBMS_SCHEDULER.CREATE_SCHEDULE(SCHEDULE_NAME   => 'rudy_scheduler',
                                 REPEAT_INTERVAL => 'FREQ=WEEKLY;BYDAY=MON,SAT,SUN');

4.创建window

  DBMS_SCHEDULER.CREATE_WINDOW(WINDOW_NAME     => 'rudy_scheduler_window',
                               SCHEDULE_NAME   => 'rudy_scheduler',
                               RESOURCE_PLAN   => 'rudy_membership_plan',
                               DURATION        => INTERVAL '60' MINUTE,
                               WINDOW_PRIORITY => 'HIGH',
                               COMMENTS        => 'THIS IS A TEST SCHEDULER WINDOW');

5.创建job

  DBMS_SCHEDULER.CREATE_JOB(JOB_NAME => 'rudy_job',
                            PROGRAM_NAME => 'rudy_program',
                            SCHEDULE_NAME => 'rudy_scheduler');