Post reply

email notification in Reporting Services

  • May 15, 2008 at 9:20 am

    #190534

    Is there a way to send an email notification from Reporting Services each time a report is run? I am not interested in setting up a subscription to receive a report, just a notification via email that the report was run.

    Thanks,

    Fred

  • May 15, 2008 at 10:21 am

    #816031

    You can put a piece of code at the end of your stored procedure which populates a dataset or you can put it as a next step in a job which kicks off your report, depending what are you using for a report trigger.

    Something like this:

    EXEC msdb.dbo.sp_send_dbmail

    @recipients = 'xxxxx@yyyyy.zzz;aaaaa@bbbbbb.ccc',

    @subject = 'here goes a subject',

    @body = 'here goes a body'

    I hope this was helpful.

  • May 15, 2008 at 10:59 am

    #816046

    Thank you for your quick reply. I will definitely give this a try.

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

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