Monitoring SSRS subscriptions

• Chrissy321

  SSCoach

  Points: 15763

  More actions

  October 15, 2012 at 9:51 am

  #263292

  Is there any comprehensive way to monitor SSRS subscriptions? I am using the below but I do not have a comprehensive list of possible errors.

  Thanks if you can help...

  SELECT

  *

  FROM subscriptions s

  WHERE

  LastStatus LIKE '%Failure%' OR

  (LastStatus LIKE '%Error%' AND LastStatus NOT LIKE '%0 Error%') OR

  LastStatus LIKE '%The e-mail address of one or more recipients is not valid.%' OR

  LastStatus LIKE '%Thread was being aborted.%'

• davdam8

  Hall of Fame

  Points: 3620

  More actions

  October 15, 2012 at 10:29 am

  #1549204

  This might help.

  http://blogs.msdn.com/b/deanka/archive/2009/01/13/diagnosing-and-troubleshooting-subscriptions.aspx%5D%5B/url%5D

  Or you monitor with PowerShell:

  http://www.youdidwhatwithtsql.com/monitoring-ssrs-subscriptions-powershell/1392