Link to home
Start Free TrialLog in
Avatar of canuckconsulting
canuckconsultingFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL Server 2012 SSRS -> Email when report subscription fails

We are running SQL Server 2012 Standard and have configured several SSRS report subscriptions to save to a file share daily.  This typically works great but when it fails we have no way of finding this out other than checking the folder to see if the report has been generated.  

We would like to configure SSRS or the associated SQL job to email us when the report generation fails for any reason.  Is this possible?  Basically we want to get away from having to manually check for problems.
ASKER CERTIFIED SOLUTION
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Seems self-serving, but my answer proposes a solution and it works for us in the same situation.