Monitor SSRS Subscription Errors
Using SSRS 2012, we utilize report subscriptions to save reports network
locations and send reports by email. I am familiar with how to debug
errors, but I am looking for a solution to alert our support team when a
subscription has failed to send. Call me crazy for being proactive.
I see a solution to monitor the ReportServer tables for status, but it
assumes all subscriptions are by email (only handles email statuses).
I also see the execution log table(ExecutionLog3), but the table doesn't
appear to capture all errors. I forced a subscription to fail by removing
network access to the file location, but the error doesn't appear in the
table.
I would like to write an SSRS report which can be run to view all
subscription errors that have occurred for a day. Any suggestions are
appreciated.
No comments:
Post a Comment