Managing SQL Reporting Services subscription failures
This is a solution I’ve had to put in place in almost all BI positions in some form or another. Its something that remains a “custom workaround” through all versions of SQL Server Reporting Services, right up to 2016.
I go into a lot of detail in my post on SQL Shack about a simple & effective way to alert on failed subscriptions using a SQL Agent job. Have a look over at SQL Shack: