Re: Scheduling a job using DBMS_JOB package

Tansel Ozkan wrote:
>
> Hello everyone,
>
> I am trying to schedule a job using the DBMS_JOB package.
> In the help file, I read the following.
>
> -- NEXT_DATE is the date at which the job will next be automatically
> run,assuming there are background processes attempting to run it.
> ********************
>
> What is meant by 'background processes'? How do these processes start?
> Are there any special operations that we have to perform before we can
> use the DBMS_JOB package?
>
> Thanks..
>
> Tansel

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

Tansel Received on Tue Feb 24 1998 - 00:00:00 CST