Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Scheduling with DBMS_JOBS

Scheduling with DBMS_JOBS

From: Peter Fithian <Pfith_at_ibm.net>
Date: Wed, 19 Jan 2000 10:05:18 -0600
Message-ID: <3885e1af_1@news1.prserv.net>


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 Received on Wed Jan 19 2000 - 10:05:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US