Re: DBMS_JOB - A follow up question

Hi Folks;

    I have been working to get DBMS_JOB up and running properly. I can submit a job to the job queue, and I can run it manually (DBMS_JOB.RUN(#)), but I can not get the silly thing to run unattended. I have these parameters set:

> set up the requisite init.ora parameters.
>
> NAME TYPE VALUE
> ----------------------------------- ------- ------------------------------
> job_queue_interval integer 60
> job_queue_processes integer 3 <_--------I requested 5

AND job_queue_keep_connections FALSE

Now here is the problem. When I look at the parameters (via TOAD) it says that job_queue_processes is set to 0. This strikes me as an obvious problem as to why it would not wake up and run the job. HOWEVER, when I spoke to my local DBA, he says that the parameter is set to 5 in the init.ora file and thinks that I am nuts. (I do not have access to show parameters to verify this.)

So here is the question. Is there some other parameter at a higher level that could be overiding what I am doing. (No jobs allowed in any instance on the server??)

Where would be a likely place that the parameter could be overridden?

Thanks in advance for any assistance anyone can provide.

Kathy Graham
kathy_graham_at_hpl.hp.com Received on Mon Aug 02 1999 - 20:02:13 CEST