Troubleshoot SQL Server Email

 EXEC msdb.dbo.sp_send_dbmail

    @profile_name = 'CVTMSsQLT02 Mailer'

   ,@recipients = 'dexter.velasco@aei.com'

   ,@subject = 'Email from SQL Server'

   ,@body = 'This is my First Email sent from SQL Server :)'

   ,@importance ='HIGH'

GO

SELECT * FROM msdb.dbo.sysmail_unsentitems

SELECT * FROM msdb.dbo.sysmail_sentitems

SELECT * FROM msdb.dbo.sysmail_faileditems

EXEC msdb.dbo.sysmail_help_profile_sp;

select

 err.[description] ,

 fail.*

FROM [msdb].[dbo].[sysmail_event_log] err

 inner join [msdb].dbo.sysmail_faileditems fail

 On err.mailitem_id = fail.mailitem_id;

sysmail_help_profile_sp