Re: DBMS_JOB question

From: Brett Neumeier <random_at_enteract.com>
Date: 20 May 1998 18:31:21 GMT
Message-ID: <6jv7hp$o8q$4@eve.enteract.com>

Igor Sereda <sereda_at_spb.runnet.ru> wrote:
> I am having several jobs running on my system. What bothers me,
> is the question: Will a running job block snpNNNN process so
> other jobs will not run until running job finishes? In that
> case it would be necessary to run one process per job to assure
> in-time job starting.

Yes. Each SNPn process will run one job queue entry at a time.

The job queue is not a very good solution for time-critical processes, because of this and because the SNPn processes only "wake up" at a particular interval. If your "job_queue_interval" is set to 300, then a job that is specified to run every hour may run one to five minutes later than you expect it to.

-bn Received on Wed May 20 1998 - 13:31:21 CDT