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,
Asked
Active
Viewed 654 times
1 Answers
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