SQL Server – Enable / Configure Replication Alerts

Replication offers the following predefined alerts, which can be configured to respond to replication events:

  • Replication: agent success
  • Replication: agent failure
  • Replication: agent retry
  • Replication: expired subscription dropped
  • Replication: Subscription reinitialized after validation failure
  • Replication: Subscriber has failed data validation
  • Replication: Subscriber has passed data validation
  • Replication: agent custom shutdown

Configure these alerts from the Alerts folder in Microsoft SQL Server Management Studio or the Warnings tab in Replication Monitor

Let us take a look how can we enable/Configure Replication Alerts; we will enable one alert for demo.

Example:

We will enable Replication: agent failure alert in such a way, once the agent fail we will get am email and it write the windows event log

Execute the attached Stored Procedure named sp_SQLNotify

So first we will create a Job under Management that sends an email

01 Enable -Configure Replication Alerts

Enable -Configure Replication Alerts

 

02 Enable -Configure Replication Alerts

Enable -Configure Replication Alerts

 

03 Enable -Configure Replication Alerts

Enable -Configure Replication Alerts

 

Now enable the alert Replication: agent failure

 

04 Enable -Configure Replication Alerts

Enable -Configure Replication Alerts

 

Click on “Enable” check Box then click Highlighted Button as above

 

05 Enable -Configure Replication Alerts

Enable -Configure Replication Alerts

 

Click on Edit Button

 

06 Enable -Configure Replication Alerts

Enable -Configure Replication Alerts

 

Click on check Box “Always write to Windows event log.

Go to Second Tab Named “Response”

 

07 Enable -Configure Replication Alerts

Enable -Configure Replication Alerts

 

Click on the check Box “Execute Job:” and select the JOB Named that we created for email.

You are done; with this configuration u will get an email once Replication agent fail and u will get an error detail in windows Event log.

Similarly you can Enable/Configure the other Replication alert according to your requirement.