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: JOB interval 1 minute but last_date - next_date < 1 min

Re: JOB interval 1 minute but last_date - next_date < 1 min

From: Andy Hardy <junkmail_at_[127.0.0.1>
Date: Fri, 25 Apr 2003 19:06:47 +0100
Message-ID: <xT8peKD3kXq+Ewmo@hardyfamily.plus.com>


In message <3ea8f659$1_1_at_news.bluewin.ch> , Roman Grigoryan <romich_at_dukascopy.com> writes
>JOB interval 1 minute but last_date - next_date < 1 min why?
>
>Job started in 15:00:00 then after 1 min have to be repeated, but the
>last_date wrote 15:00:02...
>
>

Have a look at your init.ora and the job_queue_interval, it's the number of seconds between job 'runs'. I believe that the default is 60, therefore no jobs will be repeated in less than 60 seconds.

Also, the job scheduler only attempts to meet your time requirements in a 'best endeavours' manner...

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849
Received on Fri Apr 25 2003 - 13:06:47 CDT

Original text of this message

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