Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Executing a script from Unix shell
Put the command you want to execute in a cron job, which automatically execute a desired command at set times or intervals.
If your SA gave you permission to execute cronjobs, you can set one up easily by executing the following command (I know this works in Solaris, don't know about other flavors of UNIX)
"crontab -e"
Which brings up a screen for you to enter the desired command.
For more detailed information, look in the man pages for crontab.
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
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
-- ----- Kevin.K.Tong_at_jpl.nasa.gov JPL IBS, (818)354-7967 Pasadena, CA 91109Received on Mon Oct 02 2000 - 11:25:39 CDT