Re: DBMS_JOBs don't start

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 07 May 1998 01:10:45 GMT
Message-ID: <355109da.2370628@192.86.155.100>

A copy of this was sent to swaczin_at_wmd.de (Helmut Swaczinna) (if that email address didn't require changing) On 6 May 1998 20:38:35 GMT, you wrote:

>Hi,
>
>I want to execute a stored procedure periodicly using the
>DBMS_JOB package. But the job doesn't run after submitting
>it with DBMS_JOB.SUBMIT. Only when I run it once manually with
>DBMS_JOB.RUN it continues to run at the specified intervall.
>I tried this with Oracle 7.3.4 under NT.
>
>Any idea?
>

commit it. you can see the job but the job queue cannot see it until you commit it. dbms_job.run does a commit and hence 'fixes' the problem....

[snip]
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed May 06 1998 - 20:10:45 CDT