Re: need help with job queue problem...

Hi,

check job_queue_processes parameter value:

select value from v$parameter where name = 'job_queue_processes';

If it is 0 your jobs are not running. You can set it without restarting database:

alter system set job_queue_processes=1;

Kai

gdas_at_my-deja.com wrote:

> Hi,
>
> I'm hoping someone might be able to help me. I have 4 oracle databases
> (version 8.1.5 on NT). 2 databases comprise a development environment
> and the other 2 comprise what will soon be a beta environment.
>
> On all 4 databases I have a stored procedure which gets the space
> capacity, freespace and used space in all the tablespaces from various
> dictionary and v$ views and inserts these values into a separate
> table. I use this to monitor the space available in the tablespaces
> and as well as track the growth of the database over time.
>
> On all 4 databases, I scheduled this procedure to run every night using
> the dbms_job package. On 3 out of the 4 databases there is no
> problem. Everything runs fine. However, it will not run on the 4th
> database (They are identically configured in terms of the init.ora
> file). The dba_jobs table shows the procedure, it shows that the
> procedure is not broken, it shows the interval as being sysdate +1,
> however the last date is null and the next date shows september 15,
> 2000 which was the day that I submitted the job. It is simply not
> firing. I confirmed the system clock on that machine was also set
> properly.
>
> I checked the procedure and it compiled without problems. The
> procedure also runs if I execute it manually. It seems as if the job
> queue is dead, or asleep. Does anyone know how I can wake it up?
>
> Any tips would be appreciated,
> Thanks,
> Gavin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 03 2000 - 02:37:06 CDT