Situation:
- no mail is send
- databasemail.exe is missing in taskmanager
- in event log "An error occurred in Service Broker internal activation
while trying to scan the user queue 'msdb.dbo.ExternalMailQueue' for its
status. Error: 1222, State: 56. Lock request time out period exceeded. This is
an informational message only. No user action is required."
Try:
ALTER
DATABASE [msdb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER
DATABASE [msdb] SET DISABLE_BROKER
SELECT
is_broker_enabled FROM sys.databases WHERE name = 'msdb' ;
ALTER
DATABASE [msdb] SET ENABLE_BROKER
SELECT
is_broker_enabled FROM sys.databases WHERE name = 'msdb' ;
ALTER
DATABASE [msdb] SET MULTI_USER
EXEC
msdb.dbo.sysmail_stop_sp;
EXEC
msdb.dbo.sysmail_help_status_sp;
EXEC
msdb.dbo.sysmail_start_sp;
EXEC
msdb.dbo.sysmail_help_status_sp;
EXEC
msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail';
