Lesson 3: Monitoring Transactional Replication

Activity 3: Configuring an Agent Failure Error

Solution:

1. Open the replication monitor and select the publication you wish to set the alert for. Select the Warnings tab in the right-hand pane:
   

   Figure 3.69: The Warnings tab

2. In the Warnings tab, click on the Configure Alerts button. In the Configure Replication Alerts dialog box, select the Replication: agent failure replication alert and click on the Configure button:
   

   Figure 3.70: The Configure Replication Alerts dialog box

3. In the Replication: agent failure alert properties window, change the database name to AdventureWorks and check the Enable checkbox besides the alert name:
   

   Figure 3.71: The Replication: agent failure alert properties window

4. Under Select a page, select the Response page. In the Response page, check Notify operators and then check the E-mail checkbox for the Alerts operator:
   

   Figure 3.72: The Response page

   Click on OK to create the alert.

5. Open SSMS, if it's...