Re: DBMS_JOB: Next Date changes

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 Tue Feb 01 2000 - 11:55:23 CST