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.
Best Answer
This does only handle the last status message so doesn't fully answer the question (I came across this post because I am looking for the same answer), but it does seem to work for me in terms of catching all subscription errors, including file share issues: