| Batch file [message #99869] |
Fri, 03 May 2002 16:07  |
sql gurus
Messages: 22
Registered: May 2002
|
Junior Member |
|
|
How to write a batch file to run an SQL program Automatically
The Batch file will be scheduled to run every day.
Any thoughts appreciated
|
|
|
|
| Re: Batch file [message #99874 is a reply to message #99869] |
Mon, 06 May 2002 09:37  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Remote:
sqlplus username/password@tnsalias @sqlscript.sql
Local:
set ORACLE_SID=SID
sqlplus username/password @sqlscripts.sql
Use "at" to schedule it. You can put the "at" command at the end or beginning of your script to resubmit after/before the script is run.
|
|
|
|
| Re: Batch file [message #100870 is a reply to message #99874] |
Wed, 28 January 2004 03:43 |
Joe
Messages: 138
Registered: November 1999
|
Senior Member |
|
|
|
I'm working in a Windows environment. I get it to start and process just fine. How do I get it to stop/exit after the script runs?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
