Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to do a job in specified time ?
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 netReceived on Sun Feb 09 2003 - 20:06:50 CST