Solved

send email if ssrs subscription fails

Posted on 2014-11-12
2
226 Views
Last Modified: 2014-11-12
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
Comment
Question by:johnnyg123
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40437463
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
 

Author Closing Comment

by:johnnyg123
ID: 40438357
Just what I was looking for!...Thanks!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question