I need to find a way to automatically make a script run against a certain instance on my dB. Is it possible? Is it possible to run scripts from the command line? SVRMGR? SQL Worksheet? SQLPlus?
Any ideas are welcome!
OCP DBA 8i, 9i, 10g
On Unix platform you can run a cron-job to automate a script.
On NT you can use TASK scheduler to run a script if you like.
Windows NT 4.0 SP6
Also, I use the scheduler service all the time, but to execute an oracle script? I thought you had to be in SQL Worksheet or SQLPlus, etc. to do that?
you can schedule to run a batch file under WinAT or AT program on Windows NT. The contents of the batchfile will be like --
C:\ORACLE\ORA81\BIN\SQLPLUSW.EXE userid/pass@hoststring @c:\scripts\Myscript.sql
Also you can go to http://www.americansys.com/ and download a free version of EZSchedular for NT. It's pretty neat !!!
Click Here to Expand Forum to Full Width