Re: DBMS_JOB question

> /* 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 - 03:52:11 CDT