canuckconsulting
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Seems self-serving, but my answer proposes a solution and it works for us in the same situation.