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 -> Re: Scheduling a Pl/Sql program

Re: Scheduling a Pl/Sql program

From: Jens Mayer <jmayer_at_ratundtat.com>
Date: Tue, 29 Sep 1998 17:57:55 GMT
Message-ID: <36111dcb.33201821@news.space.net>


On Tue, 29 Sep 1998 00:04:35 GMT, "Boris Oblak" <boris.oblak_at_siol.net> wrote:

>I have similar problem on OpenVMS, Oracle 7.3.2.3.0. Try to increase
>job_queue_processes in init.ora.
>
>In my configuration works fine:
>job_queue_processes = 2
>

I have made the same experience on Windows NT, Oracle 7.3.?.?

Seems that oracle uses one process for the job-queue-scheduler. By the way: I tried to use an interval of 1 minute, but oracle executed the job NOT every minute. An interval of 5 minutes worked better. Has anyone had the same problem ?

Jens Received on Tue Sep 29 1998 - 12:57:55 CDT

Original text of this message

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