Re: HELP: DBMS_JOB QUESTION

The next time is set from the END of the job completion. You job appears to take about 40 seconds, so each restart slips another 40 seconds.

A reasonably safe solution in your case is to change the formula from sysdate + 1/96 to something which truncates the sysdate to the nearest 15 minutes and then adds 15 minutes.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Huiming Li wrote in message <37E736A2.115ABB9E_at_jis.ne.jp>...
>Hi, everybody,
>
>I expect my job to execute automatically every 15 minutes (exactly!).
>Is there a way?
>
>The following is what I have done and the result.
>
>Initialization parameters:
> job_queue_processes = 1
> job_queue_interval = 60
>
>execute dbms_job.submit(:jobno, 'XYZ;', SYSDATE, 'SYSDATE + 1/96');
>
>what I got:
>
> The 1st Time 15:40:13 (expected time 15:40:00)
> The 2nd Time 15:55:40 (expected time 15:55:00)
> The 2nd Time 16:11:20 (expected time 16:10:00)
> ....
>
>It seems that the error is getting larger and larger.
>
>Thanks in advance.
Received on Tue Sep 21 1999 - 03:07:06 CDT