How to suspend next run of Oracle Job?

677 Views Asked by At

I have a job which is scheduled to run at a specified time daily. How do I stop it from running from its next schedule only? It should then run as usual in successive schedules. Thanks,

1

There are 1 best solutions below

0
On

Since you're using the dbms_job package rather than the more recent dbms_scheduler package, you can just call next_date

begin
  dbms_job.next_date( <<your job number from dba_jobs>>,
                      <<the date you want it to run next>> );
  commit;
end;