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!

Jobs run an hour late

810042Nov 2 2010 — edited Nov 9 2010

I had posted this in Database - General, but I think it is more applicable here:

Hello,

I am having a strange issue. I have jobs that get created and put into user_jobs with the NEXT_DATE and NEXT_SEC set to the sysdate. However the jobs don't run until an hour passes. This just started happening on Sunday, so I believe this is related to the changes in Daylight Savings Time. The clock on the OS and the SYSDATE of the database are correct. I checked v$timezone_file and it is at version 4.

Let me know if there is any further information that will help, but I need to know what causes the jobs to run, and why it is waiting an hour. (This is happening in one specific environment, but is not happening in many others, so I believe that it is not related to the code or jobs themselves)

Oracle 10.2.0.4 Enterprise Edition.

Thanks,
Ben

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2010

Added on Nov 2 2010

#database-key-features, #scheduler

8 comments

502 views