Alert Notifications

• gregalbrecht 41264

  Newbie

  Points: 3

  More actions

  December 10, 2012 at 5:10 pm

  #286070

  Hi,

  Can someone give me a script to mannually test alert subscriptions. I have set them up (19-25), configured DB mail and created an operator.

  I would like to use t-sql to actually test the alerts.

  Many thanks

  greg

• j.miner

  SSCrazy

  Points: 2264

  More actions

  December 10, 2012 at 6:06 pm

  #1567224

  Hi There,

  I wrote a series of articles about alerts last October.

  If fact, I wrote an article on testing alerts that has the code you are looking for.

  Enjoy

  http://craftydba.com/?p=1130

  John Miner

  Crafty DBA

  http://www.craftydba.com

  John Miner
  Crafty DBA
  www.craftydba.com