Oracle dbms_scheduler - react to change of system date

I've got a dbms_scheduler-Job running in Oracle 10.2.0.

When I change the system date back to yesterday, the job will wait for one day to continue its work. The reason for this is that next_run_date does not change.

This does not happen regularly, but sometimes someone decides to change the system date without thinking or even knowing about oracle jobs running.

Any suggestions on how to keep my job running with the configured interval (without having it to change manually)?

Answers


If you are changing the system date out from underneath Oracle, your hands might be tied. Is there a reason you are regularly changing the system date? If so, perhaps you should create a script for doing so, and have that script also update next_run_date.


Need Your Help

Send string to Form3 from Form2

c# .net winforms visual-studio-2010

I am using Form2 to update the default printer and send the string to Form3. I typically have no problem operating from Form1 and passing data to Form2 or Form3. But having trouble using Form2 to

Implementing efficient foreign keys in a relational database

mysql sql-server postgresql

All popular SQL databases, that I am aware of, implement foreign keys efficiently by indexing them.