Receive the following error in the SQL Logs:
The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The service queue "ExternalMailQueue" is currently disabled.
When I go to activate the ExternalMailQueue, it goes into Receives_Occurring state for about 5 seconds, and then back to inactive.
When I query the ExternalMailQueue, I show one record, but nothing that really stands out. From what I've read, it could be a bad message that is causing the Queue to go into inactive state?
Has anyone run into this message before and any solutions to fix? Is there a way to flush out what's in the queue, then set it to active?