How to: Set Thresholds and Warnings for a Snapshot Publication (Replication Monitor)

Specify thresholds on the Warnings and Agents tab. If a threshold is met or exceeded, a warning is displayed in Replication Monitor. You can also have an alert sent to you. For Distributors running versions prior to Microsoft SQL Server 2005, this tab is labeled Agents and only displays information about agents used by the publication. You cannot set thresholds for these publications.

For snapshot replication, you can specify a threshold for imminent subscription expiration.

To view more information about the options on this tab click Help on the top menu. For information about starting Replication Monitor, see How to: Start Replication Monitor (Replication Monitor).

  1. Expand a Publisher group in the left pane, expand a Publisher, and then click a publication.

  2. Click the Warnings and Agents tab.

  3. Enable a warning by selecting the check box Warn if a subscription will expire within the threshold.

  4. Set a threshold for the warning in the Threshold column. For example, you could select a value of 70% in the Threshold column.

  5. Click Save Changes.

  1. Click Configure Alerts.

  2. In the Configure Replication Alerts dialog box, select an alert, and then click Configure.

    This dialog box displays alerts for all publication types, including alerts that are not related to monitoring thresholds. For more information, see Setting Thresholds and Warnings in Replication Monitor and Using Alerts for Replication Agent Events.

  3. Set options in the <AlertName> alert properties dialog box:

    • On the General page, click Enable; specify which database the alert should apply to.
    • On the Response page, specify whether an e-mail should be sent and/or a job should be executed.
    • On the Options page, customize the text of the response.
  4. Click OK.

  5. Click Close.

Community Additions