Oracle 定时器脚本

–查看在执行的定时器

SELECT job, next_date, next_sec, failures, broken FROM user_jobs;

–删除定时器

Begin
  dbms_job.remove(24); -- 24就是上面查出来的定时器编号
Commit;
End;

begin
  sys.dbms_job.change(job => 63,
                      what => 'DRUG_INP_BILL;',
                      next_date => to_date('29-12-2020 14:20:54', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'TRUNC(sysdate,''mi'') + 1/ (24*60)');
  commit;
end;

/