Re: DBMS_JOB starting job

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 14 Dec 2001 14:19:38 GMT
Message-ID: <3c1a09ec.2159477703@news.alt.net>

On Fri, 14 Dec 2001 10:35:30 +0100, "Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> wrote:

>Hi !
>
>Oracle 8.1.6 / NT4.
>
>I got i trouble with jobs :
>
>When I create a job with SUBMIT and parameter NEXT_DATE=sysdate, it works
>fine, and runs again considering the INTERVAL.
>
>When I create a job with SUBMIT and parameter NEXT_DATE=sysdate+(1/48)
>(starts in 30min.), and an interval of 30 min, the job never starts.
>The job is not broken.
>
>Any ideas ?
>
>Thanks.
>
>Yann
>
>

Did you make sure the job lists NEXT_DATE correctly after you submit and commit it?

Brian Received on Fri Dec 14 2001 - 08:19:38 CST