SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 query result auto save file & schedule,email
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

usafelix
Posting Yak Master

Hong Kong
103 Posts

Posted - 08/28/2014 :  04:49:19  Show Profile  Reply with Quote
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

India
693 Posts

Posted - 08/28/2014 :  04:58:57  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
one of the options is to use SSRS and subscribe the reports

Javeed Ahmed
Go to Top of Page

usafelix
Posting Yak Master

Hong Kong
103 Posts

Posted - 08/28/2014 :  06:14:01  Show Profile  Reply with Quote
Have any freeware tools ?
Go to Top of Page

suvendupatra
Starting Member

1 Posts

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

pkrana1980
Starting Member

Canada
3 Posts

Posted - 09/05/2014 :  12:33:32  Show Profile  Reply with Quote
you can do it using powershell or using SSRS as described earlier.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000