Skip to Main Content
Forums

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!

Enabling a scheduler job

Tim BJul 10 2012 — edited Jul 10 2012
Hi,

I have a 10.2.0.1 development database in a windows environment. I made a scheduler job that runs every minute. Since it's a dev server, our developer tried to simulate a scenario which changes the server date to a date in the future. Now the last run of my scheduled job (as queried from dba_scheduler_jobs) was a date in the future and when the server date was brought back to the current date, the job stopped from running.

How will I enable the job to run again? According to the dba_scheduler_jobs, it is still enabled.

Edited by: Tim B. on Jul 10, 2012 1:48 AM
This post has been answered by Lakmal Rajapakse on Jul 10 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2012
Added on Jul 10 2012
#database-key-features, #scheduler
2 comments
137 views