Re: dbms_job question

Ed Stevens wrote:
>
> I'm just starting to play around with dbms_job, and have another 'what
> am I seeing here' question.
>
> Environment is Oracle 8.1.7.0.0 EE on Solaris v8
>
> The server in question has 2 databases. Yesterday (Wed, April 2) I
> submitted the same job to both databases, thus:
>
> variable jobno number;
> begin
> dbms_job.submit(:jobno,
> 'mvxjdta.refresh_schema_stats;',
> sysdate,
>
> 'TRUNC(LEAST(NEXT_DAY(SYSDATE,''THU''),NEXT_DAY(SYSDATE,''FRI'
> ') )) + 06/24');
> COMMIT;
> END;
>
> This morning (Thurs, Apr 3 06:55) a check of ?????? on one db looks
> exactly like I'd expect. LAST_DATE is 3-Aprl 06:00:35 and NEXT_DATE
> 4-Aprl 06:00:00. However on the other DB I'm seeing LAST_DATE is null
> and NEXT_DATE is 2-Apr 7:13:21. Neither shows any failures and BROKEN
> is 'N'.

any trace files in bdump? There were some bugs in 8.0 where the dates could jumpbled and thus jobs ran all over the shop, but I didn't think they made it into 8.1

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"