Re: DBMS_JOBs not running

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Wed, 7 Nov 2001 18:53:55 -0000
Message-ID: <tujnpds9andl72@corp.supernews.com>

We have seen cases where you need to do

exec dbms_job.run(JOBNO)

One time to 'kick' start the process.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Chuck" <chuck_hamilton_at_yahoo.com> wrote in message news:9sc8cg$12j9nn$1_at_ID-85580.news.dfncis.de...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I have an 8.1.7 database where jobs submitted with DBMS_JOB.SUBMIT
> will not run. They get into the job table just fine but never run.
> The related parameters are okay.
>
> NAME TYPE VALUE
> - ------------------------------------ -------
> - ------------------------------
> job_queue_interval integer 60
> job_queue_processes integer 4
>
>
> The snpX background processes are running but have accrued no CPU
> time. There are no trace files indicating that the jobs have failed.
> What would cause this database to suddently stop running jobs?.
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBO+mk32m5A4kkb4ZsEQILWQCZAV45CdWiSzBGKGuOczpCmJOZtrAAoNTm
> g0OdqLQEBOZf2rjPO4Vld+q8
> =bk8n
> -----END PGP SIGNATURE-----
>
>
>
Received on Wed Nov 07 2001 - 12:53:55 CST