Re: DBMS_JOB question

Close parens after the TRUNC, something like:

dbms_job.submit(jobnum,'tempinsert;', trunc(sysdate)+97/96).

This will give you today's midnight plus one day and 15 minutes.

hth,

Yosi

Chetan Wagle wrote:

> 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 - 14:44:45 CDT