Alert not working.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  August 13, 2008 at 4:12 am

  #382235

  Has any one successfully setup alerts for transactional replication latency?

  I have selected "Warn if latency exceeds the threshold" and threshold = 30 seconds.

  I have selected alert "Replication Warning: Transactional replication latency (Threshold: latency)"

  Eventhough latency exceeds 30 seconds, it is not working. No email is sent. There is no entry in the application event log.

  'Replication: Subscriber has failed data validation' and 'Replication: agent retry' are working.

• Red8Rain

  Hall of Fame

  Points: 3312

  More actions

  August 20, 2008 at 5:36 pm

  #860953

  is there an operator setup? is your server setup to send out notification?

  I wouldn't rely on those latency BS SQL got, it didn't do me any good in the past. I ended up writing my own replication check.

  -----------------------------
  www.cbtr.net
  .: SQL Backup Admin Tool[/url] :.