Re: DBMS-JOBS

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/01/07
Message-ID: <34b3fe67.10547733@www.sigov.si>#1/1

On Wed, 07 Jan 1998 10:02:32 -0600, sgans_at_rocketmail.com wrote:

>Hi
>
> I am having a problem in using DBMS-JOB package.
> The jobs in the queue are not triggering automatically.
> I had to use run to trigger it for the first time.
>
> I have set the job process parameter to 2. i have also
> checked that two snp process is running.
>
> can somebody throw some light.

The job will not be processed until you isue a commit in a session from which the job was submited. No DBMS_JOB package procedure contains implicit commit - the only exception is DBMS_JOB.RUN (remember this when you want to change something in a submited job or want to remove it - it won't happen until you commit!).

So just isue a COMMIT after you submit/isubmit the job.

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Jan 07 1998 - 00:00:00 CST