How can i generate reports of Server DashBoard,costly queries etc., to my mail automate?

• CH&HU-1021641

  Ten Centuries

  Points: 1387

  More actions

  March 3, 2009 at 1:02 am

  #197659

  Dear All,

  As am working in a developing company, i would like to automate the things as i have mentioned in Subject.

  There was a problem with our LogShipping process. I would like to have the reports to be generated to my mail or to my local machine from production in the form of excel or pdf files. Will that be possible through ManagementStudio only. if not using Reporting Server?. Any process for this will be appreciated.

  Thanks,

  CH&HU.

• d_gomes2

  SSC-Addicted

  Points: 406

  More actions

  March 4, 2009 at 5:06 am

  #953013

  Hi

  I can create a daemon for execute some tasks at some hour.

  I have made one in vb.net that get my information, create the report and send it by email.

  If yoy google it find a lot of examples.

  But you also have this altarnative http://www.sqlservercentral.com/articles/SSIS/62678/

  Cumpts

  DG