Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Job submitted with DBMS_JOB wont run

Job submitted with DBMS_JOB wont run

From: Patrick J. <patrickREMOVE.jTHIS_at_kneip.com>
Date: Mon, 3 Jun 2002 17:41:28 +0200
Message-ID: <3cfb8e22_1@news.vo.lu>


Hi,

I submitted a job via DBMS_JOB.SUBMIT. This was accepted and I can see the job in USER_JOBS view.
But the job never starts (the last date is always null).

The parameters seem to be OK:
job_queue_interval=60
job_queue_processes=4

I can even see the snp processes when issuing a 'ps' command, but nothing happens.

The database is 8.1.7 running on Suse Linux 7.2.

What is wrong?

Patrick J. Received on Mon Jun 03 2002 - 10:41:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US