HOW TO: Stop DB mail alerts

• srinivas.akyana

  Ten Centuries

  Points: 1269

  More actions

  January 17, 2016 at 5:36 pm

  #314946

  Hello,

  While I was testing few things, I wrongly kept sp_send_dbmail in infinite while loop however after I realized that, I did stop the query and disabled the SQL job (my code is part of an Stored Procedure which runs thru a job). However, I have been still getting emails (in fact 5 - 8 emails per second, my email is literally flooded) and I did stop the mails using "sysmail_stop_sp" and even changed the mail configuration to 0 from 1 in XP_CONFIGURE yet I am receiving emails.

  Please can you help me out here on how to stop the emails?

  Thanks!

• Justin Manning SA

  Hall of Fame

  Points: 3190

  More actions

  January 18, 2016 at 3:20 am

  #1852465

  You might need to clear the queue:

  http://fkauffmann.blogspot.co.uk/2012/01/sql-server-database-mail-how-to-clear.html