NEXT_RUN_DATE before current date
518459Sep 26 2008 — edited Dec 1 2008Hello,
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