Re: DBMS_JOB ?

From: Garry Lawton <Garry.Lawton_at_uibk.ac.at>
Date: 1997/06/30
Message-ID: <5p8e5t$cna$1_at_dm2.uibk.ac.at>#1/1


In article <33B7ABAF.A6950452_at_bryan.prestel.co.uk>, bryan_at_bryan.prestel.co.uk says...
>
>This is a multi-part message in MIME format.
>--------------6E3272C26EE271506014A708
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Hi,
>
>I'm attempting to use DBMS_JOB from PL/SQL 2.1.6 on Oracle Server 7.1.3.
>
>The package exists, I can use it to submit, and remove jobs, and these
>jobs are visible through the DBA_JOBS view. I can even run a job,
>explicitly.
>
>However, the jobs don't run on schedule,

Hi Bryan,

   I think that the job_queue_processes parameter is not set in init.ora ?

Regards Garry


Garry Lawton                                      Tel: 43-512-507-2314
EDV-Zentrum der Universitaet Innsbruck            Fax: 43-512-507-2944
Technikerstr. 13 
6020 Innsbruck, Austria                e-mail: garry.lawton_at_uibk.ac.at
----------------------------------------------------------------------
Received on Mon Jun 30 1997 - 00:00:00 CEST

Original text of this message