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