Conflict Alerts

• jyusko

  SSC Rookie

  Points: 27

  More actions

  September 8, 2009 at 8:13 am

  #209750

  I am very new to replication and we occasionally get some conflicts on a specific article that are easy to resolve but cause reporting issues if we do not know about them. Is there any way to configure an email alert when there are conflicts on a specific article?

• abv_by

  SSC Journeyman

  Points: 95

  More actions

  September 30, 2009 at 5:21 am

  #1059876

  Script for alert creation (merge replication):

  USE [msdb]

  GO

  EXEC msdb.dbo.sp_add_alert @name=N'Conflict',

  @message_id=0,

  @severity=0,

  @enabled=1,

  @delay_between_responses=0,

  @include_event_description_in=0,

  @category_name=N'[Uncategorized]',

  @performance_condition=N'SQLServer:Replication Merge|Conflicts/sec|Merge Replication Agent Job you wish to monitor|>|0',

  @job_id=NewID()