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 = ‘Default Profile’, @recipients = ‘yourame@yourDmain.com’, @subject = ‘Try #1 Read more…