Re: DBMS_JOB INTERVAL PARAMETER TIP

Oh, I interpreted
> regardless of when the previous run completed.
as
"regardless of whether the previous job failed or succeeded".

Still, I have some doubts. As far as I know the new run time is calculated when the job is finished, but I can't check it right now. If so, then next_sec can be 16:00:00, but I really doubt that next job being started before 16:00:48! The Oracle scheduler just scans the all_jobs table every now and then, and triggers the jobs which are due, or overtime. So, if at 4 p.m. you submit a job to run at 2 p.m., then indeed Oracle will start running it as soon as it scans the job tables. Still, the job can never be run before you submit it...

Arjan.

>After reading your post I checked the job to make sure. The Last_Sec
>field in user_jobs says 16:00:48 and the Next_Sec says 16:00:00 so I guess
>it's working.
Received on Sun Jul 19 1998 - 00:00:00 CDT