need help with job queue problem...

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 Wed Sep 27 2000 - 13:51:54 CDT