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 ?
"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