Alert when replication has failed

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  October 2, 2015 at 9:52 am

  #303577

  What are the different options for setting up Alerts when Replication stops or errors out?

  I ran this code on the publisher:

  USE [msdb]

  GO

  /****** Object: Alert [Replication: agent failure] Script Date: 10/2/2015 11:42:46 AM ******/

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

  @message_id=14151,

  @severity=0,

  @enabled=0,

  @delay_between_responses=0,

  @include_event_description_in=5,

  @category_name=N'Replication',

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

  GO

  It already existed.

  So I ran it on the Subscriber and it executed.

  Are there any third party tools to do this?

  Thanks.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  October 2, 2015 at 10:01 am

  #1831101

  I found this link but what about the subscriber?

  https://www.mssqltips.com/sqlservertip/1901/customized-alerts-for-sql-server-transactional-replication/

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/