Re: DBMS_JOB starting job

The two last lines of my initSID.ora are :

JOB_QUEUE_PROCESSES = 10
JOB_QUEUE_INTERVAL = 60 Yann

Sławomir Marcinkowski a écrit dans le message <9vcrg8$19i$1_at_news.tpi.pl>...
>did You set up JOB_QUEUE_PROCESSES parameter in your initSID.ora?
>Slawek
>
>Użytkownik "Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> napisał w
>wiadomości news: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 Fri Dec 14 2001 - 06:38:25 CST