SQLServer数据库邮件异常信息获取

场景：SQLServer数据库邮件发送无法自动获取邮箱厂商的信息返回的信息进行通知

 

--获取当天数据库邮件发送失败的信息
SELECT '发送日期','发送时间','状态','收件人', '标题', '内容', '发送文件'
UNION ALL 
SELECT CONVERT(VARCHAR,ISNULL(send_request_date,''),23),
CONVERT(VARCHAR,ISNULL(send_request_date,''),8),ISNULL(sent_status,''),ISNULL(recipients,''), 
ISNULL(subject,''),ISNULL(body,''),ISNULL(file_attachments,'')
FROM msdb.dbo.sysmail_allitems(NOLOCK) 
WHERE DATEDIFF(DAY,send_request_date,GETDATE()) = 0 
AND sent_status = 'failed'