Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NEXT_RUN_DATE before current date

518459Sep 26 2008 — edited Dec 1 2008
Hello,

I'm wondering whether having an entry in the ALL_SCHEDULER_JOBS with the field NEXT_RUN_DATE filled with a date that's before the current date would trigger the launch of the job on Oracle instance startup?

The problem I'm having: I'm making backups of an Oracle instance. Some of my scheduled jobs would run daily. If I take a backup today, the backupset will include the ALL_SCHEDULER_JOBS. If I recover the backupset, say, a week from now, when I re-open my instance, the table will include some jobs that have the next running date at some moment in the past. What will happen at the startup of Oracle? Will it launch all the jobs that are scheduled and should have been ran in the past?

Thank you,
Adrian
This post has been answered by Rnr-Oracle on Oct 2 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2008
Added on Sep 26 2008
3 comments
4,878 views