My company uses SSRS to deliver reports to users, either by email subscriptions or by the user opening the Report Server page in their browser and clicking on the report they want, which then runs it against the db. I call this "Interactive mode".
My users are supposed to tell me when a report fails, so I can go fix it, but most of the time they don't.
So I need to go looking for failed reports. I can already see which email subscription reports have failed using the subscriptions report in SSRS, but I need a way to either generate an email or log a row to a table whenever one of the interactive mode reports fails.
I can't see anything obvious in Visual Studio that would allow me to do this, has anyone come up with a solution for this before?
It turns out there's a very helpful table in the ReportServer database named "ExecutionLog" which has exactly these details.