Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Scheduling with DBMS_JOBS
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