Re: Running an SQL script from C Shell (Unix)

In article <8ra9ud$nju$1_at_nnrp1.deja.com>,   jpebejer_at_maltanet.net wrote:
>
>
> I have a script (myscript.sql) which I want to run AUTOMATICALLY each
> time from the shell through some sort of scripting (on a UNIX box).
>
> Aren't there some command line parameters to do this ?
> Say SQL*Plus myscript.sql ?
>
> Many Thanks
> JP
>

Look up cron in the manual pages or the dbms_job package in the database if what you want to do can be done in pl/sql.

For a cron job you would need to set the Oracle environment and then you could use this line to execute your script sqlplus userid/password @smyscript.sql

Because this is a cron job you would also need to cd to the correct directory or full path all filenames in the shell script and your spool file to be sure they are found/written to the correct location.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.