Re: DBMS_JOB question

From: Chetan Wagle <cwagle_at_ctp.com>
Date: Tue, 21 Sep 1999 17:11:21 +0530
Message-ID: <7s7qq8$olo$1@herald.ctp.com>

The format that u submitted the job will mean that the next time of execution will get calculated (sysdate+24.25/24) AFTER THE CURRENT JOB COMPLETES. So, if tonights job finishes at 00:30, then tomorrow night execution happens after 24hrs and 15 mins ie at 00:45.

That explains the delay.

HTH,
Chetan

Huiming Li wrote in message <37E7473B.193C52C6_at_jis.ne.jp>...
>> /* this procedure would be invoked at 00:15 and then subsequently
>> the same time there after ie 00:15 each midnight*/
>
> Are you really sure that the batch execute at 00:15 each day? no delay?
>
> I am suffering from time delay every day, say, first day 00:15:15,
>second day
> 00:16:05, something like that.
>
>>
>> dbms_job.submit(jobnum,'tempinsert;',
>> trunc(sysdate+24.25/24,'sysdate+1');
>>
>> end;
>> /
>>
Received on Tue Sep 21 1999 - 06:41:21 CDT