Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 tools sql query, auto schedule+ auto save txt file

Author  Topic 

usafelix
Posting Yak Master

165 Posts

Posted - 2014-08-28 : 22:47:28
Anyone can give idea in market , Have any software tools can run the query and auto direct output txt or excel file , with auto schedule auto this query result into excel or text file send to email ?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-29 : 02:38:03
If it's a scheduled query , the steps you requires can be completed using SQL Server Agent and DBMail.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-29 : 02:38:06
If it's a scheduled query , the steps you requires can be completed using SQL Server Agent and DBMail.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

usafelix
Posting Yak Master

165 Posts

Posted - 2014-08-29 : 02:49:25
SQL Server agent can run the sql query but the result cannot auto save in text file ? I want to direct run the sql query then output file with use dbmail send out it.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-29 : 09:53:26
Check this post , in the 'query attachments' section near the end , which outlines how to execute a query and attach it as a file to the email.
http://www.sqlserver-dba.com/2011/01/set-up-database-mail-on-sql-server-2005.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -