schedule program job 关系

来源：互联网发布：aes数据加密器编辑：程序博客网时间：2024/05/18 23:56

我们还可以把前几篇讲的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.txtschedule program job  2014/08/15 周五 16:48:10.39schedule program job  2014/08/15 周五 16:48:20.38schedule program job  2014/08/15 周五 16:48:25.34schedule program job  2014/08/15 周五 16:48:30.38schedule program job  2014/08/15 周五 16:48:35.38schedule program job  2014/08/15 周五 16:48:40.38

0 0