Re: DBMS_JOB: Next Date changes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 25 Jan 2000 20:49:36 +0800
Message-ID: <388D9BE0.F45@yahoo.com>

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." Received on Tue Jan 25 2000 - 06:49:36 CST