Re: DBMS_JOB question

There is a configuration parameter somewhere that tells Oracle how frequently it's supposed to check for Jobs in queue. Cannot remember which one :-(
If this time is 15 minutes, it'll only check every 15 minutes so jobs can be to late.....

Sorry I can't help you more. This is probably in the manuals.

Huiming Li wrote:

> > /* 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;
> > /
> >

--
Bjarni Ragnarsson
bjarnir_at_centrum.is Received on Tue Sep 21 1999 - 08:50:50 CDT