Share via

  • Article

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

Specify thresholds on the Warnings 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 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).

To set thresholds and warnings for a transactional publication

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

  2. Click the Warnings 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.

To configure an alert for a threshold

  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.