using a batch file to automate SQLTalk

[dalex17]

Hello,

Can I get some assistance on creating a quick and simple batch file (is this even the correct group)? I am a first time creator of a batch file and am not finding the internet very resourceful.

My goal is to do the following:

1) Open a program (SQLTalk)
2) Open a file
3) Run the file
4) Close the program

Dalex

 

[ModelTrains]

Dalex,
I run batch jobs every night. Email me:

scevem@totalshow.com

NOTE: This is a business email and unsolicited emails will be investigated and appropriate action will be taken.

 

[ModelTrains]

OK, I found the process. It is scheduled to run nightly and runs a script. The script spools the output to a text file. SQLTalk closes itself when the job is done. This can be run through a scheduler or via a BAT file. The following command is all on one line:

C:\Centura\sqltalk.exe BAT INPUT=Q:\BACKUP\KEYVALS\UnloadKeyvalsAllBranches.sql

 

[dalex17]

Modeltrains,

This is fantastic. Thanks. I guess I will create a batch file and enter the info as you have suggested above. I'll e-mail you if I run into an problems.

Also, if you have any additional comments, I deeply welcome them.

Thanks again!

Dalex