Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Job queue Question
On Wed, 07 Jul 1999 13:46:08 -0700, Glen Upreti <Glen.Upreti_at_nau.edu> wrote:
<snip>
>I don't think that the interval of sysdate +1 will be really good,
>because I think it might start to slide, that is set itself to the
>sysdate of whenever the job completes plus 24 hours which means that if
>your job takes 1/2 an hour then then next_date will be 6:30 tommorrow
>and then after that 7;00 the next day etc...
This is not correct. The interval is evaluated immediately before the job starts executing. But you are correct that the job may "slide". But, this is a function of both the number of job_queue_processes you have and the interval that they wake up at, as pointed out by Jurij Modic in a follow up to my initial posting to this thread. ( Thanks again Jurij for catching my omission of '+1' in the interval ).
chris.
--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.