SQL & PL/SQL

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!

dbms_job runs an hour late?

wolfeetJul 9 2004 — edited Jul 9 2004

I have a job set up to run on both the test and production servers. I have the job scheduled to run at 11:00 p.m. each night. (I think) It runs at 2 minutes past midnight for some reason. There is only one job in the user_jobs and dba_jobs tables.

SQL>select last_date,last_sec from user_jobs;
Returns: 09-JUL-04 and 00:02:14.

SQL>select next_date,next_sec from user_jobs;
Returns: 09-JUL-04 and 23:00:00.

Interval = trunc(sysdate)+23/24

What is causing this job to get delayed by one hour? There are no other jobs and there are 10 job_queue_processes. Oracle 9.2.0.4

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 6 2004

Added on Jul 9 2004

6 comments

557 views