Data Alert Manager for Alerting Administrators


Applies To: SQL Server 2016

Reporting Services provides Data Alert Manager for SharePoint alerting administrators to manage data alerts. Alerting administrators can view information about all alerts saved to the site and delete alerts. The following picture shows the features available to SharePoint alerting managers in Data Alert Manager.

Alert Manager for SharePoin tsite administrators

When the site is enabled for data alerts, two SharePoint pages, MyDataAlerts.aspx and SiteDataAlerts.aspx are created and added to the SharePoint site. SiteDataAlerts.aspx is Data Alert Manager for alerting administrators. Alerting administrators can open Data Alert Manager from the Site Settings SharePoint page. Alerting administrators must have SharePoint Manage Alerts permission to open Data Alert Manager.

You can also open Data Alert Manager directly by using a URL. The following shows the syntax of the URL:

http: //<site name>/_layouts/ReportServer/ SiteDataAlerts.aspx

System_CAPS_ICON_note.jpg Note

As an alerting administrator, you can grant permission to information workers to access the Reporting Services data alerts features. For more information about the required permissions, see Reporting Services Data Alerts.

When Reporting Services is installed and configured in SharePoint, the Site Settings SharePoint page includes the Reporting Services options. Alerting administrators click the Manage Data Alerts option within Reporting Service to open Data Alert Manager. The following picture shows from where on the Site Settings page you open Data Alert Manager.

Reporting Services section of Site Settings page

Data Alert Manager includes a table that lists the alert name, report name, the name of the alert owner, the number the alert message was sent, the last time the alert was run, the last time the alert definition was modified, and the status of the alert message. If the alert cannot be generated or generated or sent, the status column contains information about the error and helps you troubleshoot the alert. For more information, see Manage All Data Alerts on a SharePoint Site in Data Alert Manager.

The following table shows sample data from a table in Data Alert Manager. When an error occurs, the error message and the identifier of the entry in the log (a GUID) are included in the Status field in the table.

Alert NameReport NameCreated BySent AlertsLast RunLast ModifiedStatus
SalesQTRSalesByTerritoryAndQTRLauren Johnson46/12/20116/1/2011Last alert ran successfully and alert was sent.
UnitsSoldProductsSalesByQTRMichael Blythe27/1/20116/28/2011Last alert ran successfully, but the data was unchanged and no alert was sent.
InventoryCountStockStatusByQTRLauren Johnson77/10/20117/2/2011<error message>The log file contains detailed information about the error. Refer to the log entry with the identifier: <GUID>.
TopPromotionPromotionTrackingCristian Petculescu05/23/2011Alert created.

For more information see, Manage All Data Alerts on a SharePoint Site in Data Alert Manager.

You can view all alerts created by site users. You choose a user and then choose whether to view all their alerts or only alerts for a specific report.

Arrow icon used with Back to Top link Back to Top

You delete alerts definitions from Data Alert Manager. Every data alert definition has an owner, the SharePoint user who created it. Owners can delete only the alert definitions that they created. For more information, see Manage My Data Alerts in Data Alert Manager.

A SharePoint alerting administrators can list and then delete alert definitions created by all users of the site. For more information, see Manage All Data Alerts on a SharePoint Site in Data Alert Manager

After you delete the alert definition, no further alerts are sent. However, if you query the alerting database you might find that the alert definition still exists. The alerting service performs clean up on a schedule and the alert definition is deleted permanently in the next cleanup. The default cleanup interval is 20 minutes. This and other cleanup intervals are configurable. For more information, see Reporting Services Data Alerts.

Arrow icon used with Back to Top link Back to Top

This section lists a procedure that shows you how to manage your alerts.

Arrow icon used with Back to Top link Back to Top

Reporting Services Data Alerts

Community Additions