Re: DBMS_JOBs don't start

In article <6iqhob$m8b$1_at_ns2.dokumenta.de>#1/1,   swaczin_at_wmd.de (Helmut Swaczinna) 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?
>
> Thanks
>
> Helmut
>
> ---------
>
> Example:
>
> execute dbms_job.submit(:n, 'job1;', sysdate+1/(60*24),
'sysdate+1/(60*24)');
>
> Waiting some minutes...
>
> select last_sec, this_sec, next_sec, interval from user_jobs;
>
> LAST_SEC THIS_SEC NEXT_SEC INTERVAL

> -------- -------- -------- -----------------
> 22:13:25 sysdate+1/(60*24)

>
> execute dbms_job.run(25);
>
> select last_sec, this_sec, next_sec, interval from user_jobs;
>
> LAST_SEC THIS_SEC NEXT_SEC INTERVAL

> -------- -------- -------- -----------------
> 22:24:09 22:25:09 sysdate+1/(60*24)
>
> select last_sec, this_sec, next_sec, interval from user_jobs;
>
> LAST_SEC THIS_SEC NEXT_SEC INTERVAL

> -------- -------- -------- ----------------
> 22:25:30 22:26:30 sysdate+1/(60*24)
>
>

I do not know about NT, but in the UNIX world you have to configure the SNP background processes for scheduling the jobs. You need at least one SNP background process, although you can configure to run more than one to run jobs submitted by DBMS_JOB.SUBMIT procedure.

Check for the INITsid.ORA parameter for starting the SNP background processes. I am not sure but it sounds like JOB_QUEUE_PROCESSES = 1 Regards

Ajay Reddy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 06 1998 - 23:18:23 CDT