Edit a Data Alert in Alert Designer

APPLIES TO: yesSQL Server Reporting Services (2016) noSQL Server Reporting Services (2017) yesSharePoint noPower BI Report Server

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

You open the data alert definition that you want to edit from Data Alert Manager. Only the user that created the alert definition can edit it. For more information about opening Data Alert Manager, see Manage My Data Alerts in Data Alert Manager.


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

The following picture shows you the context menu on a data alert in Data Alert Manager.

Open Data Alert Designer by clicking Edit

The following procedure includes the steps to open the alert definition for editing in Data Alert Designer from Data Alert Manager.

To edit a data alert definition in Data Alert Designer

  1. In Data Alert Manager, right-click the data alert definition that you want to edit and click Edit.

    The alert definition opens in Data Alert Designer.

  2. Update the rules, schedule settings, and email settings. For more information, see Data Alert Designer and Create a Data Alert in Data Alert Designer.


    You cannot choose a different data feed. To use a different data feed, you must create a new data alert definition.

  3. Click Save.


    If the report has changed and the data feeds generated from the report have changed the alert definition might no longer be valid. This occurs when a column that the alert definition references in its rules is deleted from the report or changes data type or the report is deleted or moved. You can open an alert definition that is not valid, but you cannot resave it until it is valid based on the current version of the report data feed that it is built upon. To learn more about how data feeds are generated from reports, see Generating Data Feeds from Reports (Report Builder and SSRS).

See Also

Data Alert Manager for Alerting Administrators
Reporting Services Data Alerts

More questions? Try asking the Reporting Services forum