3

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,

Bishnu Paudel
  • 2,083
  • 1
  • 21
  • 39

1 Answers1

1

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;
Justin Cave
  • 227,342
  • 24
  • 367
  • 384