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

How to avoid database deadlocks

java concurrency db2 deadlock

I have a clustered application that is suffering from database deadlocks.

Styles not applied in IE8 but in Chrome and Firefox they are

jquery html css google-chrome internet-explorer-8

I have the following html in a website. The stylings specified in "ApplicationName_ButtonDiv", "ApplicationName_Button" etc are applied correctly in Chrome and Firefox but in IE8 they aren't.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.