I have noticed that when a data driven subscription (report sent via email attachment) succeeds, 'status' from the report manager will express something similar to "Done: 1 processed of 1 total; 0 errors." If the subscription is not data driven, 'status' for successful execution is similar to 'Mail sent to Me@Email.com' What I am trying to do is to reference Subscription.Status or something in a log file that will give me a consistent way to be made aware of subscription errors right after they occur. The problem I have is that I have no notification of any kind when a subscription fails, and I find out about report delivery failures from the user. Ideally, once a subscription error/failure is detected, some form of notification would be generated. I don't see that there is a consistent way that I can interrogate Subscription.Status for success/failure information. Are there logs I can reference? Are there third party solutions out there that make subscription error handling easier to manage? Thank you for your help! cdun2

Hi cdun2, Based on my experience, the SSRS would not send out a notification, but will log an entry to its log files when error occurs. Report server administrators can review the reportserverservice_*.log files to determine subscription delivery status. For e-mail delivery, report server log files include a record of processing and deliveries to specific e-mail accounts. The files are saved at :\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles The log file does not include information about whether the report was opened, or whether the delivery actually succeeded. Successful delivery means that there were no errors generated by the Scheduling and Delivery Processor, and that the report server connected to the mail server. If the e-mail resulted in an undeliverable message error in the user mailbox, that information will not be included in the log file. For more information about log files, please check Reporting Services Log Files: http://msdn.microsoft.com/en-us/library/ms157403%28v=SQL.100%29.aspx 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.

Hi cdun2, Based on my experience, the SSRS would not send out a notification, but will log an entry to its log files when error occurs. Report server administrators can review the reportserverservice_*.log files to determine subscription delivery status. For e-mail delivery, report server log files include a record of processing and deliveries to specific e-mail accounts. The files are saved at :\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles The log file does not include information about whether the report was opened, or whether the delivery actually succeeded. Successful delivery means that there were no errors generated by the Scheduling and Delivery Processor, and that the report server connected to the mail server. If the e-mail resulted in an undeliverable message error in the user mailbox, that information will not be included in the log file. For more information about log files, please check Reporting Services Log Files: http://msdn.microsoft.com/en-us/library/ms157403%28v=SQL.100%29.aspx 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. Thanks. I will see what I can do with this.

cdun2 - With SSRS 2005, I remember a service that went through the logs once a day and stored the information in a db on the reporting server... this way you could run reports against it to find out information like the top executed reports, execution status codes, and more... not sure about you, but I don't want to have to look through log files to get this info. Right now I am trying to dig around for it to see if I can also find something that works for 2008 R2 and will post back if I can find it. Cheers, Eric

I knew it was out there... just had to find it. Here is a link to the MSDN article talking about it: http://msdn.microsoft.com/en-us/library/ms155836(v=SQL.100).aspx and here is a link to the server management report samples on codeplex: http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008!Server%20Management%20Sample%20Reports I have not set this up yet in my 2008 R2 environment, but this type of solution worked great with SSRS 2005. Hope this helps! Eric

Came back around to this again today and wanted to put clear instructions out there for me (if I have to do it again) or anyone else having issues as I and lots of others out there did as well... got it up and running now though! This was definitely more difficult setting up for 2008 R2 than it was for 2005. The download for 2008 OR 2008 R2 can be found here: http://sqlserversamples.codeplex.com/releases/view/30803 use the readme for setting up everything but the SSIS package... for this I found some great instruction here: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/71369/ Hopefully this saves someone a bit of time :)