automate sql

• cory.bullard76

  Ten Centuries

  Points: 1232

  More actions

  March 16, 2016 at 7:33 am

  #305734

  Does SQL Server Management Studio have the option to automate a query (and dump it in Excel) and email to people?

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  March 16, 2016 at 7:40 am

  #1865600

  cory.bullard76 (3/16/2016)

  ---

  Does SQL Server Management Studio have the option to automate a query (and dump it in Excel) and email to people?

  SSMS is a client tool and does not have that option.

  The database engine has several extended procedures to do that through the SQL Agent. I believe that the Agent also has specific tasks to send mail if you don't want to stay with sp_send_dbmail.

  You could also do that with subscriptions on SSRS.

  Or automate an SSIS package.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Jon.Morisi

  SSChampion

  Points: 12846

  More actions

  March 16, 2016 at 9:17 am

  #1865640

  Check this (first google result):

  http://www.sqlservercentral.com/Forums/Topic1156421-391-1.aspx

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736260

  More actions

  March 16, 2016 at 9:38 am

  #1865652

  There are a few more: http://www.sqlservercentral.com/articles/powershell/130717/

  http://www.sqlservercentral.com/articles/Excel/64838/

  Really you need a driver, which can be some scheduler. SQL Agent, Windows Scheduler, etc.

  Then you need automation. There are numerous ways, but if you want to export a query, bcp, Excel Macros, and more work fine.