Re: Job Queue

From: Jurij Modic <jmodic_at_src.si>
Date: Mon, 14 Jun 1999 19:11:28 GMT
Message-ID: <37655148.412871_at_news.siol.net>

On 14 Jun 1999 05:14:18 GMT, "Todd" <toddlee_at_ms4.url.com.tw> wrote:

>We try to use the 'Job Queue' in our MIS system.
>
>I have submit a job in queue but it don't execute though dbm_jobs.run works
>fun.
>
>Are there somethings I do not know to let job queue works automatically?

Submitting a job is in fact a transaction. Enter COMMIT after you submit a job with DBMS_JOB.SUBMIT and the job will be processed automatically.

DBMS_JOB.RUN has an implicit commit built in - that's why your job is processed after you run this procedure, even if you don't issue a COMMIT yourself.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Jun 14 1999 - 21:11:28 CEST