SELECT is_broker_enabled FROM sys.databases WHERE name = ‘msdb’;
EXECUTE msdb.dbo.sysmail_help_status_sp;
–if stopped then run
EXECUTE msdb.dbo.sysmail_start_sp;
sql for everyone
sql for everyone
SELECT is_broker_enabled FROM sys.databases WHERE name = ‘msdb’;
EXECUTE msdb.dbo.sysmail_help_status_sp;
–if stopped then run
EXECUTE msdb.dbo.sysmail_start_sp;