Re: Scheduling with DBMS_JOBS

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 19 Jan 2000 20:08:40 +0800
Message-ID: <3885A948.5108@yahoo.com>

Peter Fithian wrote:
>
> Hello;
>
> Does anyone know what the format would be to schedule a job every 12 hours?
> I know that for once every 24 hours, its:
>
> DBMS_JOB.ISUBMIT(vJobNum, 'job_name;', SYSDATE, 'TRUNC(SYSDATE) + 1 +
> 20/24');
>
> But I don't know what it would be for the 12 hour deal.
>
> Anyone?
>
> Thanks very much if you can help me.
>
> Peter Fithian
> Pfith_at_attglobal.net

1 = 1 day
1/2 = 12 hours

1/24 = 1 hour

etc
--

---

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 Wed Jan 19 2000 - 06:08:40 CST