Data Alert Manager for alerting administrators

Applies to: ✅ SQL Server Reporting Services (2016) ❌ SQL Server Reporting Services (2017) ✅ SharePoint ❌ Power BI Report Server

For content related to previous versions of SQL Server Reporting Services (SSRS), see SQL Server 2014 Reporting Services.

SQL Server 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.

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

View data alert information

When Reporting Services is installed and configured in SharePoint, the Site Settings SharePoint page includes the Reporting Services options. Alerting administrators select 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.

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 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.

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.

Delete data alerts

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.

Related tasks

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

• Manage all data alerts on a SharePoint Site in data alert manager

Related content

• Reporting Services data alerts

More questions? Try asking the Reporting Services forum