Hi , Is there a way to notify a user if a snapshot for a report fails on a given day? Regards, Vikram Kansal

Hi Vikram Kansal, Of course, it will show up the error message when the snapshot failed due to some reason( eg. Timeout), you can also see the status of snapshot in the Trace Log file, which includes records application log events, errors and exceptions, low resource warnings, report delivery details, and other details about reporting services operations. You can use any text editor to view the file. This file is located at \Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles. For more information about Trace log please see http://msdn.microsoft.com/en-us/library/ms156500(v=SQL.105).aspx Besides, you can also check the Report Server Execution Log, Source of the report execution and status field is captured in the report execution log, whose value are: (1=Live, 2=Cache, 3=Snapshot, 4=History). For more information about Report Server Execution Log, please see: http://msdn.microsoft.com/en-us/library/ms159110.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Challen Fu, Thanks for your reply but what I am looking for is an automated notification being sent to the user or administrator when a snapshot fails. Please correct me if I am wrong the methods that you have mentioned requires someone to monitor the logs etc. what I am looking for is an automated email being sent to the user/admin mentioning snapshot failed for a certain report. Is it possible? Regards, Vikram

Hi Vikram, Currently, there is such a build-in feature to achieve this requirement, thanks for your understanding, However here I would still recommend you to submit a feedback to Microsoft Connect at this link at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation. Regards, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Challen Fu, Thanks for your response. and I understand that there is no in built feature but can you suggest a way which we can still implement on our own? or none is possible? Regards, Vikram Kansal

Hi Vikarm, SQL Server Reporting Services provides access to the full functionality of the report server through the Report Server Web service. The Report Server Web service is an XML Web service with a SOAP API. It uses SOAP over HTTP and acts as a communications interface between client programs and the report server. The Web service provides two endpoints - one for report execution and one for report management - with methods that expose the functionality of the report server and enable you to create custom tools for any part of the report life cycle. There are three primary ways to develop Reporting Services applications based on the Web service. You can: Develop applications using Microsoft Visual Studio and the Microsoft .NET Framework SDK. For more information about using the .NET Framework to build Web service applications, see Building Applications Using the Web Service and the .NET Framework. Develop applications using the rs utility (RS.exe), the Reporting Services script environment. With Reporting Services and Visual Basic scripts, you can run any of the Report Server Web service operations. For more information about scripting in Reporting Services, see Scripting with the rs Utility and the Web Service. Develop applications using any SOAP-enabled set of development tools. For more information, see The Role of SOAP in Reporting Services. Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Thanks Challen Fu.