Automated Query iSQL

25 pts.
Tags:
Automated SQL Query
isql
SQL
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: January 29, 2012  12:33 AM
UPDATED: February 28, 2012  10:53 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TechTalker
    What platform (operating system) are you running iSQL on?
    2,310 pointsBadges:
    report
  • Loveisalluneed3
    Windows XP Pro version 2002 service pack 3.
    25 pointsBadges:
    report
  • Loveisalluneed3
    Any suggests where I might go to learn how to set up a DOS command shell?
    25 pointsBadges:
    report
  • TechTalker
    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.
    2,310 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following