Re: DBMS_JOB: Next Date changes

Thanks everyone.. job_queue_interval was set to 600 (although I'm not sure about what units that is), I moved it to 10 and am awaiting results tonight. processes is 10 as well. Only 2 jobs, spaced 3 hours apart.

• Dc.

Thomas Kyte wrote:

> A copy of this was sent to Doug Cowles <dcowles_at_us.ibm.com>
> (if that email address didn't require changing)
> On Tue, 01 Feb 2000 11:46:03 -0500, you wrote:
>
> >I do have a trunc in my next_date, and although the job doesn't slip on a
> >daily basis,
> >it doesn't execute when it's suppossed to (10:00pm). The job takes less
> >than a
> >second to run, yet it always exeutes at 10:07pm.
> >Have a look at these values for the job:
> >LAST_DATE = 31-JAN-00
> >LAST_SEC= 22:07:53
> >NEXT_DATE = 01-FEB-00
> >NEXT_SEC=22:00:00
> >
> >Yesterday, the values reported were the same (although one day back).
> >Why is it always 7 minutes late?
> >- Dc.
> >
>
> what is your job_queue_interval?
> what is your job_queue_processes?
>
> if you interval is too large -- jobs won't run near their scheduled time. for
> example, say the interval was 10 minutes. If you started the database at
> 11:57am, then jobs would be processed every 10 minutes from there (10:07, 10:17,
> 10:27 and so on).
>
> if you have too few processes and a couple of jobs scheduled for the same time -
> you'll get a backlog as well. only as many jobs as you have queue processes can
> be running simultaneously. If you have 1 process and 2 jobs scheduled for 10 --
> and the first job takes 7 minutes, this can happen as well.
>
> >
> >Connor McDonald wrote:
> >
> >> Richard de Fonseka wrote:
> >> >
> >> > I can submit a job to run at exactly 11:00pm:
> >> >
> >> > execute
> >> > dbms_job.isubmit(300,'apl.update_msf600_comparison();',trunc(sysdate)
> >> > + 23/24,'sysdate+1');
> >> >
> >> > When I check ALL_JOBS after the job executes, the Last Date changes
> >> > (e.g. 11:02pm) and the Next Date changes as well.
> >> >
> >> > I have tried to change the Next Date using DBMS_JOB.CHANGE at the end
> >> > of the procedure being executed.
> >> >
> >> > How do I keep the start date/time to exactly 11:00pm.
> >> >
> >> > Thanks,
> >> > Richard
> >>
> >> Use trunc in your next definition.
> >>
> >> HTH
> >> --
> >> ===========================================
> >> Connor McDonald
> >> "These views mine, no-one elses etc etc"
> >> connor_mcdonald_at_yahoo.com
> >>
> >> "Some days you're the pigeon, and some days you're the statue."
> >
> >
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Thu Feb 03 2000 - 14:45:48 CST