Re: how to schedule a job every day

Likely the problem is the value set for JOB_QUEUE_INTERVAL in the instance's init.ora file. If it needs to execute exactly at 10:00PM you will need to modify this parameter to a value less than 60.

But understand that this means that Oracle will have a bit more overhead every single minute (or less) checking for jobs to run even though it has none.

Daniel A. Morgan

ceiling wrote:

> HI ALL:
> We need to create a job which run in 10:00PM every day,
> when set the interval to 'sysdate+1',it seem work fine. But
> after a few day,
> there are two problem occur:
> 1.the job execution time although approximately 10:00PM, but
> incremental every day,like
> day 1: 10:00PM
> day 2: 10:05PM
> day 3: 10:08PM
> but we want the job run in 10:PM every day
> 2.when we shutdown database in some day, and startup in
> another day.
> Suppose startup in 09:00AM,
> we find the job's next_date would be altered to 09:00AM
>
> how can we solve these problem. Thanks in advance
Received on Wed Mar 21 2001 - 00:26:32 CST