Re: Jobs do not run

From: Martin T. <0xCDCDCDCD_at_gmx.at>
Date: Fri, 03 Aug 2007 17:30:51 +0200
Message-ID: <46b34b2d$0$1345$834e42db@reader.greatnowhere.com>

sybrandb wrote:

> On Aug 3, 3:57 pm, "Martin T." <0xCDCDC..._at_gmx.at> wrote:

>> Hello.
>>
>> DB = Oracle9i Release 9.2.0.1.0 - Production
>> OS = Windows XP sp2
>>
>> Our test database refuses to run any jobs. CJQ0 is there, but does not
>> start up any Jxxx processes.
>>
>> We tried everything (including restarts and reboots) described in
>> Metalink note 313102.1 which includes checking for
>> JOB_QUEUE_PROCESSES=0, server uptime, removing and recreating all jobs,
>> checking some obscure settings, ...
>>
>> We've really no clue what to do now. All the jobs are there in the
>> dba_jobs (user_jobs) view but only the next_date is set (to time in the
>> past) last_date and this_date are both (null) and checking active
>> sessions we can see that CJQ0 is running but no Jxxx processes.
>>
>> We have also checked the alter log etc. and found nothing obvious.
>>
>> Any ideas where else to look?
>>
>> thanks!
>> Martin

> 
> correct procedure is
> begin
> dbms_job.submit
> end;
> /
> --!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
> commit
> /
> or it will hang 4ever.
> 

Thanks for pointing this out.
Naturally one would assume that after restarting the database and even the machine the jobs still being there may still not be committed. :-P

> You do have a CSI, do you? You are using this for production purposes,
> do you?
> If so, why did you never upgrade?
> Follow Daniels advice and go to 9.2.0.8 or Oracle will drop the phone
> on you.

The problem only exists in our test db instance (at the moment)

I fully expected you and Daniel to tell me that. (Given the fact that there are 7 patch sets we haven't even looked at it might even have some foundation.)

Let's for a moment assume we were running Oracle 10g2 with the newest patch and hit this. What would you propose except calling Oracle?

Best regards, and don't be sad that some people only patch a running system when they hit a problem that is solved by patching.

cheerio,
Martin Received on Fri Aug 03 2007 - 10:30:51 CDT