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: Richard Nield <richard.nield_at_ntlworld.com>
Date: Sun, 9 Feb 2003 20:27:28 -0000
Message-ID: <PQy1a.1518$mH4.349@newsfep1-gui.server.ntli.net>


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

Original text of this message

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