DBMS_JOB: Next Date changes

From: Richard de Fonseka <rdefonseka_at_scnet.com.au>
Date: Tue, 25 Jan 2000 17:34:43 GMT
Message-ID: <388ddd2a.3096492@news.iinet.net.au>

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 Received on Tue Jan 25 2000 - 11:34:43 CST