DBMS_JOB

From: Dirk Tschentscher <dirkTHIS_at_REMvolkswagen.de>
Date: Tue, 4 Feb 2003 10:20:44 +0100
Message-ID: <b1o0le$9tt7@doiweb4.volkswagen.de>

Hello !
We've got two databases

Test        8.1.6.0.0 (where I have dba access) with Windows NT 40 SP6
prod       8.1.7.2.0 (where I don't have dba access) some kind of Unix (I

don't know...)
with the identical parameters
job_queue_interval = 60 and
job_queue_processes = 10.

I submit my job with the following procedure :

Procedure zz_job_start is
  jobno number;
BEGIN
   dbms_job.submit(jobno,'STAMM_AUFTRAEGE_ABARBEITEN;',

                   sysdate,'sysdate + (1/(30*24))'); -- alle 2 Minuten

EXCEPTION WHEN others THEN
  dbms_output.put_line(sqlerrm);
END; In the test environment, everything works fine, but in prod nothing happens...

I can start the job with dbms_job.run, then the job works correct, but it doesn't run the next time...

Has anyone a hint what I can do ?

Rgds

    Dirk Received on Tue Feb 04 2003 - 03:20:44 CST