Troubleshooting Database Mail - MS Sqlserver

Make sure database memory option is not using AWE to allocate

To determine if Database is enabled

• sp_configure 'show advanced', 1;
  GO
  RECONFIGURE;
  GO
  sp_configure;
  GO

To enable Database mail

• sp_configure 'Database Mail XPs', 1;
  GO
  RECONFIGURE;
  GO

To restore the sp_configure procedure to its default state

• sp_configure 'show advanced', 0;
  GO
  RECONFIGURE;
  GO

To confirm that Database Mail is started

• EXEC msdb.dbo.sysmail_help_status_sp;

if the database mail activation is not started then

• EXEC msdb.dbo.sysmail_start_sp;

To check the mail queue status

• EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail';

To determine which accounts are successful in sending email

• SELECT sent_account_id, sent_date FROM msdb.dbo.sysmail_sentitems;

To view the error message returned by Database Mail

• SELECT * FROM msdb.dbo.sysmail_event_log;