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
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 query result auto save file & schedule,email

Author  Topic 

usafelix
Posting Yak Master

165 Posts

Posted - 2014-08-28 : 04:49:19
Anyone have idea what kind of tools is easily to run the sql query result and auto save result file with allow set the time schedule to submit this query result by email to other users ?

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-08-28 : 04:58:57
one of the options is to use SSRS and subscribe the reports

Javeed Ahmed
Go to Top of Page

usafelix
Posting Yak Master

165 Posts

Posted - 2014-08-28 : 06:14:01
Have any freeware tools ?
Go to Top of Page

suvendupatra
Starting Member

1 Post

Posted - 2014-09-04 : 03:06:35
Use sqlcmd command to execute, email, save the result and can schedule using windows at command
Go to Top of Page

pkrana1980
Starting Member

3 Posts

Posted - 2014-09-05 : 12:33:32
you can do it using powershell or using SSRS as described earlier.
Go to Top of Page
   

- Advertisement -