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: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 21 Jan 2003 10:06:07 +0100
Message-ID: <1043139921.216967@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 Tue Jan 21 2003 - 03:06:07 CST

Original text of this message

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