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!