Re: Dbms_job question
From: Raymond Allo <idefix_at_sydney.net>
Date: Mon, 19 Oct 1998 11:02:22 +1000
Message-ID: <362A8F9E.D41B2357_at_sydney.net>
Date: Mon, 19 Oct 1998 11:02:22 +1000
Message-ID: <362A8F9E.D41B2357_at_sydney.net>
Marcela,
The answer to your question is to make sure you have only one
job_queue_process.
Set the init.ora parameter job_queue_processes=1.
It will handle only one job at the time.
The job queue is not very sophisticated. If your have 2 or more processes
configured, you cant assign a job to a specific "queue process".
HTH
Raymond
marcela hunter wrote:
> Des any one know of an easy way to run jobs that have been submited with
> dbms_job.submit only one at a time kind of like FIFO. And only run the next
> job after the previous one has completed.
Received on Mon Oct 19 1998 - 03:02:22 CEST