sql发送邮件问题？邮件怎么判断他是否发送成功

如题所述

查看所有发给danw但是未成功的记录USE msdb ;
GO

SELECT items.subject,
items.last_mod_date
,l.description FROM dbo.sysmail_faileditems as items
INNER JOIN dbo.sysmail_event_log AS l
ON items.mailitem_id = l.mailitem_id
WHERE items.recipients LIKE '%danw%'
OR items.copy_recipients LIKE '%danw%'
OR items.blind_copy_recipients LIKE '%danw%'
GO

温馨提示：内容为网友见解，仅供参考

当前网址：https://11.t2y.org/zz/f7qfsps444sfqm7p8q4.html