Re: Jobs do not run

From: sybrandb <sybrandb_at_gmail.com>
Date: Fri, 03 Aug 2007 07:39:50 -0700
Message-ID: <1186151990.729745.108850@22g2000hsm.googlegroups.com>

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.

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.

--
Sybrand Bakker
Senior Oracle DBA

Received on Fri Aug 03 2007 - 09:39:50 CDT