Remove unsent database email from SQL Server

To stop SQL Server for sending unwanted mails we required to clean the unsent mail from database mail queue. We can do this by running below queries.

1.  SELECT * FROM msdb.dbo.sysmail_event_log;
2. -- To get number of unsent emails
3. select count(*) from msdb.dbo.sysmail_unsentitems;
4. -- remove all the unsent emails
5. delete from msdb.dbo.sysmail_unsentitems;

Now all the unexpected email hav been removed from SQL Server database mail queue.