怎么知道sql server中未传送的邮件 [英] how know the undelivered email in sql server

问题描述

我通过sql server发送电子邮件。如果知道sql server中未传送的电子邮件？gmail将返回未送达电子邮件如何知道sql server中的未送达电子邮件

解决方案

< blockquote>使用msdb;

从sysmail_allitems中选择sent_status

您将获得sysmail_allitems中所有未发送的email.see发送状态

否，你并不是真的通过SQL服务器发送它，即使它可以参与其中。在一般情况下，您不会获得有关未传递邮件的信息。即使你这样做，该消息至少应该到达提供此类服务的真正存在的邮件传递代理，但情况并非总是如此。如果你试图发送一些消息，你将不会得到任何回复。

-SA

i am sending email through sql server.how to know the undelivered email in sql server?gmail will return undelivery email how to know the indelivery email in sql server

解决方案

use msdb;
select sent_status from sysmail_allitems
you will get all the unsent email.see sent status in sysmail_allitems

No, you are not really sending it via SQL server, even though it can be involved. In general case, you get no information on undelivered messages. Even if you do, the message at least should reach the really existing mail delivery agent which provides such service, which is not always the case. If you try to send some message nowhere, you won't get any response.

—SA

这篇关于怎么知道sql server中未传送的邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！