The Command Line version of QueryToDoc exports SQL Server and Oracle data to Excel, Word, HTML, or CSV files and then automatically emails the SQL Server and Oracle query results to selected email recipients.
1. Store your queries in text files.
2. Define database connections, output type (Word, Excel, HTML, CSV), output file locations, and e-mail recipients in an ini file of parameters. This file also contains a link to the file that holds the query you want to use.
3. Run the program from the command line to either save the query results to a file or to email them to selected recipients as defined in the ini file.
4. To export and email SQL Server and Oracle reports on a schedule, start by creating a cmd file that points to the parameter file you want to use.
Then use Windows Scheduler to run the program on the schedule you define.
5. After the program runs your mail recipients will get an email with an attachment that has the query results in the format you selected.
Copyright 2012 QueryToDoc. All rights reserved.