DBMS_JOBs not running

From: Chuck <chuck_hamilton_at_yahoo.com>
Date: Wed, 7 Nov 2001 16:17:22 -0500
Message-ID: <9sc8cg$12j9nn$1@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 - 15:17:22 CST