Re: Scheduling a job using DBMS_JOB package

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/02/24
Message-ID: <34f34408.4876722@www.sigov.si>#1/1

On Tue, 24 Feb 1998 10:17:13 -0500, Tansel Ozkan <tansel_at_openix.com> wrote:

>Thanks to all who replied. The result of my own research on this matter
>is as follows:
>
>For version 7.x, the name of the parameter that has to be put in the
>init.ora file is
>
> snapshot_refresh_processes=2
>
>For version 8.0, it is:
>
> job_queue_processes - number of background processes (SNP?) to spawn
>on database startup.
> job_queue_interval - Number of seconds between checking the job
>queue for jobs to be run

A small correction. snapshot_refresh_* parameters were introduced in version 7.1 and were replaced with job_queue_* parameters in version 7.2. They are valid since then, not since Oracle8.

>Tansel

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Feb 24 1998 - 00:00:00 CST