Skip to content

Latest commit

 

History

History
63 lines (45 loc) · 3.45 KB

manage-all-data-alerts-on-a-sharepoint-site-in-data-alert-manager.md

File metadata and controls

63 lines (45 loc) · 3.45 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords monikerRange
Manage all data alerts on a SharePoint site in Data Alert Manager
Learn how to view the data alerts that any site user creates along with information about the alerts. Also, learn how to delete alerts.
kfollis
kfollis
09/25/2024
reporting-services
reporting-services
how-to
updatefrequency5
managing, alerts
managing, data alerts
>=sql-server-2016 <=sql-server-2016

Manage all data alerts on a SharePoint site in Data Alert Manager

[!INCLUDEssrs-appliesto] [!INCLUDEssrs-appliesto-2016] [!INCLUDEssrs-appliesto-not-pbirsi] [!INCLUDEssrs-appliesto-sharepoint-2013-2016i]

SharePoint alerting administrators can view a list of the data alerts that any site user creates along with information about the alerts. Alerting administrators can also delete alerts. The following picture shows the features available to alerting administrators in Data Alert Manager.

:::image type="content" source="../reporting-services/media/rs-alertmanagersite.gif" alt-text="Screenshot of the Data Alert Manager showing the features available to alerting administrators.":::

Note

Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

View a list of alerts created by a site user

  1. Go to the SharePoint site where data alerts definitions are saved.

  2. On the Home page, select Site Actions.

  3. Scroll to the bottom of the list and select Site Settings.

  4. Under Reporting Services, select Manage Data Alerts.

  5. Select the down arrow by the View alerts for user list and select the user whose alerts you want to view.

  6. Select the down arrow next to the View alerts for report list and choose a specific alert to view, or select Show All to list all alerts created by the selected user.

A table lists the following pieces of information: - Name - Report name - Name of the person who created the data alert - Number times the data alert was sent - The last time the data alert definition was modified - Status of the data alert

If the data alert can't be generated or sent, the status column contains information about the error and helps you troubleshoot the problem.

Delete an alert definition

  • Right-click the data alert that you want to delete and select Delete.

    [!NOTE]
    After you delete the alert, no further alert messages 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 content