Featured
SQL Server Database Mail – Diagnose and Resolve Issues
To Check the mail service status EXEC msdb.dbo.sysmail_help_status_sp; To Stop and Restart Mail Queue/ Service EXEC msdb.dbo.sysmail_stop_sp;EXEC msdb.dbo.sysmail_start_sp; To Check Sent and Unsent Email SELECT * FROM msdb.dbo.sysmail_sentitems;SELECT * FROM msdb.dbo.sysmail_unsentitems; To manually send a test email EXEC msdb.dbo.sp_send_dbmail @profile_name...
Read more