Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Scheduling a Pl/Sql program
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