dbms_job question

From: Ed Stevens <nospam_at_noway.nohow>
Date: Thu, 03 Apr 2003 08:01:47 -0600
Message-ID: <eveo8vspm8oc5ltf077opltk74qk16tuhi@4ax.com>

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'. Received on Thu Apr 03 2003 - 08:01:47 CST