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

Web application to user instant messaging

messaging

What options are available for receiving instant alerts from web applications?

How to prevent http requests forgery if the content is private? (basically allow only requests from my interface , not browser)

php csrf-protection

Sorry for asking this again but ppl seem to connect csrf only with form submissions or form duplication (idk why).