Scheduling and emailing custom reports

  • Hi all,

    I have downloaded MS's performance dashboard report and installed. I wanted these report should automatically send the performance report to my email.

    Could we able to do that? Please help.

    Cheers,

    Got an idea..share it !!

    DBA_Vishal

  • Admittedly I've never used the add-on MS performance dashboard reports, but are they standard RDL files? If so you can publish them to your report server and setup a Subscription to email them to you at a set time each day. You'll just need to configure the Email portion of SSRS, but doing that doesn't require the service to be restarted.

    If these reports are only accessible through SSMS by right-clicking on the DB and choosing Reports, I'm not sure there is a way to schedule those directly.

    Update: I found an article showing how to publish these reports to SSRS. It's referencing SQL 2005 and 2008, but I assume this will work just the same on 2012:

    http://blogs.technet.com/b/rob/archive/2010/09/28/hosting-the-performance-dashboard-reports-in-ssrs.aspx

    Take care,

    Sam

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply