Re: Job queue Question

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 07 Jul 1999 20:34:25 GMT
Message-ID: <3786b5f0.7111263@news.siol.net>

On Wed, 07 Jul 1999 20:06:05 GMT, clbeck_at_us.oracle.com (Christopher Beck) wrote:

>On Wed, 07 Jul 1999 19:31:48 GMT, amerar_at_ci.chi.il.us wrote:
>
> ....[SNIP]....
>So basically, your jobs is set to run every 18 hours. What you want is...
>
>VARIABLE jobno number;
>begin
> DBMS_JOB.SUBMIT(:jobno,
> 'cash_man.water_pull;',
> trunc( sysdate ) + 18/24,
> 'sysdate');

---

This is a typo, it should be 'sysdate+1'. However with this type of interval definition, each subsequent job execution time will be slightly shifted, depending on the number of job queues and their "awakening" interval. Over time you might find that your job is starting around 7 p.m. instead of 6 p.m.

To avoid this you should use an "anchor" in the interval parameter of a job, e.g.

DBMS_JOB.SUBMIT(:jobno,

                'cash_man.water_pull;',
                 trunc( sysdate ) + 18/24,
                'TRUNC(sysdate) + 1 + 18/24');
                 **************************

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Jul 07 1999 - 15:34:25 CDT