Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Scheduling with DBMS_JOBS
It should solve your problem
DBMS_JOB.ISUBMIT(vJobNum, 'job_name;',
SYSDATE, 'TRUNC(SYSDATE) + 1/24');
regards,
Anil
In article <3885e1af_1_at_news1.prserv.net>,
"Peter Fithian" <Pfith_at_ibm.net> 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
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jan 20 2000 - 14:01:32 CST