Re: need help with job queue problem...

Common problem with jobs (with me). You have to commit when you submit :) (or remove)b

On Tue, 03 Oct 2000 10:37:06 +0300, Kai Regi <kai_at_rs.ee> wrote:

>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 Wed Oct 04 2000 - 00:01:15 CDT