Home » Infrastructure » Windows » Batch file
Batch file [message #99869] Fri, 03 May 2002 16:07 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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?
Previous Topic: VB and Oracle Server connection problem.
Next Topic: installation problem of 9i on windows 98
Goto Forum:
  


Current Time: Fri Mar 29 04:20:26 CDT 2024