I have been looking at different ideas regarding notifications when Report Manager subscriptions fail. I came across two resources, 'Server Management Report Samples'; http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008%21Server%20Management%20Sample%20Reports&referringTitle=Home and the 'SQL Server Monitoring Mangement Pack'; http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=10631 Do either of these solutions provide for reporting/notification of subscription failures? I'm trying not to 'recreate the wheel' in coming up with a solution around this. If these solutions don't provide for this, can you provide links to resources for existing solutions? Thank you for your help! cdun2

You may want to look into this query: SELECT c.path, s.laststatus, s.[description] AS descript, s.lastruntime FROM reportserver.dbo.subscriptions s INNER JOIN reportserver.dbo.catalog c ON c.itemid = s.report_oid WHERE s.lastStatus LIKE '%fail%' ORDER BY 1 I have this query saved but haven't used it since I was running SSRS 2000. So, I'm not sure if it still works this way on other versions. It may need some tweaking. If you get it working I guess you could turn it into a data driven report so that it will be emailed to someone on a schedule. I have not used the Microsoft SQL Server Management Pack so I'm unfamilar with it.

Hi cdun2, According to your description, you would like to receive notification emails when subscription failed, right? Please correct me if my understanding is wrong. If that’s the case, I suggest you creating a data driven subscription based on the query that Tim have provide, step by step to create a data driven subscription for a report, please refer to the following article: Defining a Data-Driven Subscription: http://msdn.microsoft.com/en-us/library/ms169972.aspx Moreover, this is just a workaround for you. I have found it is a known issue in reporting service: Notification of SSRS subscription when it fails, I suggest you can vote it as important and hope Microsoft improve this feature in the next service pack or product release. Thanks, Eileen Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.