Home > IT Answers > Development > Automated Query iSQL
Loveisalluneed3
25 pts.
 Automated Query iSQL
isql, SQL, Automated SQL Query
I am very new to SQL and only have experience running my queries though iSQL Version 10 Build 3960 where I manually type (copy & paste) my queries. I would like to schedule a specific query to run at certain hours each day and then save the results to an excel or text file. Is this possible? How?

Software/Hardware used:
iSQL version 10 build 3960
ASKED: Jan 29, 2012  0:33 AM GMT
UPDATED: February 28, 2012  10:53:54 AM GMT
RELATED QUESTIONS
TechTalker
2,250 pts.
Answer Wiki:
You can schedule tasks in Windows XP using the task scheduler and here is a link to a Microsoft technet article that shows you how to schedule recurring tasks/jobs - http://support.microsoft.com/kb/308569. All you need to do is put your iSQL commands in a DOS command shell script and schedule the script to run or schedule the iSQL command to run with the command flags if you will be running only one command.
Last Wiki Answer Submitted:  Jan 29, 2012  12:47 AM (GMT)  by  TechTalker   2,250 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

What platform (operating system) are you running iSQL on?

TechTalker
 2,250 pts.
 

Windows XP Pro version 2002 service pack 3.

Loveisalluneed3
 25 pts.
 

Any suggests where I might go to learn how to set up a DOS command shell?

Loveisalluneed3
 25 pts.
 

You can start with a real simple DOS script by just putting the iSQL command that you usually run from the command prompt into a file with the extension .bat like mysqlscript.bat, then you can run the mysqlscript.bat from the command line by just typing the script name and hitting the return key. Once you have that working you can schedule the mysqlscript.bat file. You can also redirect the output from the iSQL command using the > character like this “isql command, command, … > c:tempmysqlfile.out” which will provide the output you are after. There are many DOS programming video tutorials on YouTube that should get you started.

TechTalker
 2,250 pts.