oracle下使用job调度存储过程

— commond line:
declare
job number;
begin
  sys.dbms_job.submit(job => :job,
                      what => ‘REPORT.PR_SCHEDULER;',
                      next_date => to_date('20-09-2016 23:59:59′, ‘dd-mm-yyyy hh24:mi:ss'),
                      interval => ‘sysdate+1');
  commit;
end;
/

— for plsql sql window:

— 新增调度job
declare job number;
begin
  sys.dbms_job.submit(job,
                      ‘REPORT.PR_SCHEDULER;',
                      to_date('22-09-2016 23:59:59′, ‘dd-mm-yyyy hh24:mi:ss'),
                      ‘sysdate+1');
  commit;
end;
— 激活job
declare jobid number;
begin
  select job into jobid from dba_jobs s where s.what='REPORT.PR_SCHEDULER;';
  sys.dbms_job.run(jobid);
  commit;
end;

— 删除无效job
begin
sys.dbms_job.remove(21);
commit;
end;

声明: 除非转自他站（如有侵权，请联系处理）外，本文采用 BY-NC-SA 协议进行授权 | 智乐兔
转载请注明：转自《oracle下使用job调度存储过程》
本文地址：https://www.zhiletu.com/archives-8353.html
关注公众号：