Oracle Database Discussions

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!

How to ensure DBMS_JOB will always run exactly at a specified time?

5108Sep 4 2007 — edited Sep 5 2007

Hi,

I have a dbms_job that runs daily at 11pm.

So, I set the job date interval as TRUNC(SYSDATE+1)+23/24.

Sometimes the job can finish before 12midnight, sometimes exceeds 12midnight, depending on the amount of transaction for the day.

When it exceeds 12midnight, I notice the next run date that calculated based on the interval becomes wrong. Eg. Today 5/Sep/2007, if it runs over midnight, the next run date will be 7/Sep/2007 11pm.

So, I wonder is there any better way of fixing the job to run at exact time using DBMS_JOB.

Please advise.

Thank you.

Regards,
Jap.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2007

Added on Sep 4 2007

#general-database-discussions

8 comments

1,444 views