schedule program job 关系

我们还可以把前几篇讲的job拆分下：
调用时间改用create_schedule
执行动作改用create_program

BEGIN
  dbms_scheduler.create_schedule(schedule_name   =>'scheduler_test',
                                 start_date      =>SYSDATE,
                                 repeat_interval =>'FREQ=MINUTELY; INTERVAL=1;BYSECOND=0,5,10,15,20,25,30,35,40,45,50,55'
                                 );
END;
/
BEGIN
  dbms_scheduler.create_program(program_name   => 'scheduler_program_test',
                                program_type   => 'EXECUTABLE',
                                program_action => 'cmd /c echo  %date% %time%>> d:\job_test.txt',
                                enabled        => TRUE);
END;
/

除了名称外，各参数设置与job里一样，对应如下：

而新的job则改为：

BEGIN
  dbms_scheduler.create_job(job_name      => 'scheduler_job_test',
                            program_name  => 'scheduler_program_test',
                            schedule_name => 'scheduler_test',
                            enabled       => TRUE);
END;

调用关系为：

好，最后来看下结果：

G:\Tools\Console2>type d:\job_test.txt
schedule program job  2014/08/15 周五 16:48:10.39
schedule program job  2014/08/15 周五 16:48:20.38
schedule program job  2014/08/15 周五 16:48:25.34
schedule program job  2014/08/15 周五 16:48:30.38
schedule program job  2014/08/15 周五 16:48:35.38
schedule program job  2014/08/15 周五 16:48:40.38