Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB starting job

Re: DBMS_JOB starting job

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Mon, 17 Dec 2001 10:04:12 +0100
Message-ID: <9vkcgn$2mj6$1@news6.isdnet.net>


Ok !
I apologize !

Works better when I commit !

Sorry.

Yann CAUCHARD a écrit dans le message <9vch5g$5bg$1_at_news2.isdnet.net>...
>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
>
>
Received on Mon Dec 17 2001 - 03:04:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US