I think it should solve your probelm
DBMS_JOB.ISUBMIT(vJobNum, 'job_name;',
SYSDATE, 'TRUNC(SYSDATE) + 1/24');
n article <3885A948.5108_at_yahoo.com>,
connor_mcdonald_at_yahoo.com wrote:
> 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."
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jan 20 2000 - 14:01:31 CST
