CDC Custom Alert

• Abdul122

  SSC Rookie

  Points: 32

  More actions

  April 24, 2024 at 3:59 am

  #4414791

  Hi All,

   

  I am writing an alert in a sql agent job, basically if my CDC latency is more than 30 minutes I should get alerted, I have tried various approaches but with not use, if any of your experts have implemented it already, can you please help me with the code.

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  April 24, 2024 at 4:41 am

  #4414796

  The only custom CDC alerting I have done for sql agent jobs is around AG failover what parameters are you currently targeting

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉