oracle 创建scheduler,job

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;

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

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

  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');

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