In SQL Server, you can use the sysmail_help_queue_sp
stored procedure on the msdb
database to see how many mail items are in the queue, the status of the queue, and when it was last activated.
There are two types of queue: the mail queue, and the status queue.
You can also return account info based on the queue type.
Continue reading