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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to do a job in specified time ?

Re: how to do a job in specified time ?

From: Andrew Allen <ajallen_at_mailhost.det.ameritech.net>
Date: Mon, 10 Feb 2003 02:06:50 GMT
Message-ID: <3E46FACE.93D950ED@mailhost.det.ameritech.net>


Richard Nield wrote:
>
> Where can you find details about using cron?
>
> "Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message
> news:1043139921.216967_at_news.thyssen.com...
> >
> > "j" <perseus_medusa_at_hotmail.com> wrote...
> > > How could I fire a sql script using cron job ? Do you mean like a perl
> > > script ?
> >
> > You can start a shell script in which you invoke sqlplus.
> > Something like 'sqlplus user/pwd_at_rdbms @script.sql'.
> > In the script.sql you can issue 'execute your_proc;'.
> > Done.
> >
> > hth,
> > Guido
> >
> >

man cron

-- 
Andrew Allen
Livonia, MI
ajalle at ameritech dot net
Received on Sun Feb 09 2003 - 20:06:50 CST

Original text of this message

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