Setup Alerts for SQL Replication

/* Typical SQL Alerts to deal with REplication. */

USE [msdb]

GO

--1.

EXEC msdb.dbo.sp_add_alert @name=N'Replication Warning: Long merge over dialup connection (Threshold: mergeslowrunduration)', 

@message_id=14163, 

@severity=0, 

@enabled=1, 

@delay_between_responses=30, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--2.

EXEC msdb.dbo.sp_add_alert @name=N'Replication Warning: Long merge over LAN connection (Threshold: mergefastrunduration)', 

@message_id=14162, 

@severity=0, 

@enabled=1, 

@delay_between_responses=30, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--3.

EXEC msdb.dbo.sp_add_alert @name=N'Replication Warning: Slow merge over dialup connection (Threshold: mergeslowrunspeed)', 

@message_id=14165, 

@severity=0, 

@enabled=1, 

@delay_between_responses=30, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--4.

EXEC msdb.dbo.sp_add_alert @name=N'Replication Warning: Slow merge over LAN connection (Threshold: mergefastrunspeed)', 

@message_id=14164, 

@severity=0, 

@enabled=1, 

@delay_between_responses=30, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--5.

EXEC msdb.dbo.sp_add_alert @name=N'Replication Warning: Subscription expiration (Threshold: expiration)', 

@message_id=14160, 

@severity=0, 

@enabled=1, 

@delay_between_responses=30, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--6.

EXEC msdb.dbo.sp_add_alert @name=N'Replication Warning: Transactional replication latency (Threshold: latency)', 

@message_id=14161, 

@severity=0, 

@enabled=1, 

@delay_between_responses=30, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--7.

EXEC msdb.dbo.sp_add_alert @name=N'Replication: agent custom shutdown', 

@message_id=20578, 

@severity=0, 

@enabled=1, 

@delay_between_responses=0, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--8.

EXEC msdb.dbo.sp_add_alert @name=N'Replication: agent failure', 

@message_id=14151, 

@severity=0, 

@enabled=1, 

@delay_between_responses=0, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--9.

EXEC msdb.dbo.sp_add_alert @name=N'Replication: agent retry', 

@message_id=14152, 

@severity=0, 

@enabled=1, 

@delay_between_responses=0, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--10.

EXEC msdb.dbo.sp_add_alert @name=N'Replication: agent success', 

@message_id=14150, 

@severity=0, 

@enabled=1, 

@delay_between_responses=0, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--11.

EXEC msdb.dbo.sp_add_alert @name=N'Replication: expired subscription dropped', 

@message_id=14157, 

@severity=0, 

@enabled=1, 

@delay_between_responses=0, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--12.

EXEC msdb.dbo.sp_add_alert @name=N'Replication: Subscriber has failed data validation', 

@message_id=20574, 

@severity=0, 

@enabled=1, 

@delay_between_responses=0, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--13.

EXEC msdb.dbo.sp_add_alert @name=N'Replication: Subscriber has passed data validation', 

@message_id=20575, 

@severity=0, 

@enabled=1, 

@delay_between_responses=0, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

--14.

EXEC msdb.dbo.sp_add_alert @name=N'Replication: Subscription reinitialized after validation failure', 

@message_id=20572, 

@severity=0, 

@enabled=1, 

@delay_between_responses=0, 

@include_event_description_in=5, 

@category_name=N'Replication', 

@job_id=N'00000000-0000-0000-0000-000000000000'

GO