Oracle Scheduler（4）job调用program和schedule
program决定做什么；schedule决定何时做；job则起到触发的作用：做。
BEGIN
dbms_scheduler.create_program (
program_name => 'my_program',
program_action => 'E:\mytest.bat',
program_type => 'EXECUTABLE',
enabled => TRUE );
END;
/
BEGIN
dbms_scheduler.create_schedule (
schedule_name => 'my_schedule',
start_date => sysdate,
repeat_interval => 'FREQ=MINUTELY; INTERVAL=1');
END;
/
BEGIN
dbms_scheduler.create_job (
job_name => 'my_job',
program_name => 'my_program',
schedule_name => 'my_schedule',
enabled => TRUE);
END;
/
BEGIN
dbms_scheduler.create_program (
program_name => 'my_program',
program_action => 'E:\mytest.bat',
program_type => 'EXECUTABLE',
enabled => TRUE );
END;
/
BEGIN
dbms_scheduler.create_schedule (
schedule_name => 'my_schedule',
start_date => sysdate,
repeat_interval => 'FREQ=MINUTELY; INTERVAL=1');
END;
/
BEGIN
dbms_scheduler.create_job (
job_name => 'my_job',
program_name => 'my_program',
schedule_name => 'my_schedule',
enabled => TRUE);
END;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29485627/viewspace-1817492/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
