Self-service Data Alerts in SSRS 2012 - Learning SQL Server Reporting Services 2012 - page 365

Self-service Data Alerts
in SSRS 2012
Self-service alerts or Data Alerts are a new feature of SQL Server Reporting Services
2012. These alerts help you monitor data of interest to you or your organization.
For example, many companies are alerting their customers when their payments
are due (which is perhaps by setting up time-triggered schedule). But Data Alerts
are triggered automatically when some data in the report changes and an e-mail is
sent. These Data Alerts are different from data-driven subscriptions in Native Mode
Reporting Services.
This feature could be very useful in monitoring inventories, monitoring stock prices,
last name changes, personnel information changes, and in many other scenarios.
Make sure you review this link from MSDN regarding Data Alerts:
http://msdn.microsoft.com/en-us/library/gg492252.aspx
In order to use this feature, you need to satisfy the following requirements:
• You must have installed SQL Server 2012 Reporting Services in the
SharePoint Integrated mode (SharePoint Server 2010).
SQL Server 2012 Reporting Services is set up as a shared service in
SharePoint Sever 2010, which means you need to configure a SQL Server
Reporting Services service, to leverage this feature. In Chapter 1 , Overview
and Installation - SQL Server Reporting Services 2012 , installing SQL Server
Reporting Services in SharePoint integrated mode was covered.
• The report for which you want to set up the data alert feature must first
be saved to a SharePoint library.
In fact you need to run the report in SharePoint to set up a data alert.