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 ?
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
>
>
Received on Sun Feb 09 2003 - 14:27:28 CST
![]() |
![]() |