Re: DBMS_JOBs not running

dbms_job.submit()
commit;

also check dba_jobs (interval, and next_time)(

On Wed, 7 Nov 2001 16:17:22 -0500, "Chuck" <chuck_hamilton_at_yahoo.com> wrote:

>-----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-----
>
>
>

.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email