How to enable/disable Alert by script

• yujinagata72

  Ten Centuries

  Points: 1072

  More actions

  August 2, 2016 at 8:48 am

  #320327

  Hi,

  If I set up an alert, is there any SQL script I can enable/disable it?

  Regards,

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  August 2, 2016 at 8:56 am

  #1893252

  sp_update_alert

  John

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  August 2, 2016 at 12:29 pm

  #1893321

  John Mitchell-245523 (8/2/2016)

  ---

  sp_update_alert

  John

  It must have taken some serious research to track this one down, John 😉

  ---