• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

send email if ssrs subscription fails

we have quite a few ssrs subscriptions set up

I know it is possible to check the status of the subscription manually but


Is there any way to set up some type of automated process to send an email if a subscription fails?
0
johnnyg123
Asked:
johnnyg123
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Have a look at this article: http://www.sqldataplatform.com/Blog/Post/14/How-to-Track-SSRS-Subscription-Failures

Of course, it won't let you know if an SSRS subscription fails because the SQL Server Agent is not running, because it relies on the Agent!
0
 
johnnyg123Author Commented:
Just what I was looking for!...Thanks!
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now