blocks|key|2685063|text|第二，重新启动SQL代理解决了问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2685064|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Second restart of SQL Agent fixed the problem.

blocks|key|2685124|text|正如您在提问中提到的，我的问题确实是代理中的邮件配置文件--谢谢您的提示。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2685125|​|2685126|📷|atomic|offset|length|2685127|2685128|这个职位底部提到的其他提示包括：|2685129|blockquote|2685130|确保在Server外围区域配置中启用DB邮件。通过右键单击服务器名称并从菜单中选择FACETS，从Facet下拉选择“server+Configuration”确保DatabaseMailEnabled的Facet属性为True。|ordered-list-item|style|BOLD|2685131|在服务器的管理文件夹中设置邮件配置文件|2685132|Server代理中的设置运算符|2685133|查看Server代理(右键单击属性)的属性，并在Alert系统页下勾选“启用邮件配置文件”，并选择在步骤2中设置的默认配置文件。|2685134|重新启动Server代理|2685135|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/f010f8d99529eb52c2e9ce3e356c3956.png|imageAlt|1|LINK|MUTABLE|url|http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3eddcf38-2223-4e04-b3f1-430ccf7e9cd8/sql-agent-failed-to-notify-operator-via-email?forum=sqlservermigration^0|0|0|0|1|0|0|0|0|4|1|0|0|0|N|0|0|4|0|A|5|0|0|A|0|0|C|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1F|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1G|8|@]|9|@$G|1H|H|1I|1|1J]]|A|$]]|$1|I|3|C|5|6|7|1K|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1L|8|@]|9|@$G|1M|H|1N|1|1O]]|A|$]]|$1|L|3|-4|5|M|7|1P|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1Q|8|@$G|1R|H|1S|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|P|7|1T|8|@$G|1U|H|1V|Q|R]]|9|@]|A|$]]|$1|U|3|V|5|P|7|1W|8|@$G|1X|H|1Y|Q|R]]|9|@]|A|$]]|$1|W|3|X|5|P|7|1Z|8|@$G|20|H|21|Q|R]]|9|@]|A|$]]|$1|Y|3|Z|5|P|7|22|8|@$G|23|H|24|Q|R]]|9|@]|A|$]]|$1|10|3|-4|5|6|7|25|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17|18|-4]]|19|$5|1A|14|1B|A|$1C|1D]]]]

As you allude to in your question, my issue was indeed the mail profile in agent - thanks for the tip.

<img src="https://i.stack.imgur.com/YRsJX.png" alt="enter image description here">

Other tips that are mentioned at the bottom of <a href="http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3eddcf38-2223-4e04-b3f1-430ccf7e9cd8/sql-agent-failed-to-notify-operator-via-email?forum=sqlservermigration" rel="noreferrer">this post</a> include:

<blockquote>
 <ol>
 <li>Ensure DB mail is enabled within the SQL Server Surface Area Configuration. Do this by right clicking the server name and selecting
 FACETS from the menu Select the 'Server Configuration' from Facet
 dropdown Ensure Facet Property of 'DatabaseMailEnabled' is True</li>
 <li>Set up a Mail Profile within the Management Folder of your server</li>
 <li>Within SQL Server Agent set up an Operator</li>
 <li>Look in the properties of the SQL Server Agent (right-click properties) and under the Alert System page tick 'Enable mail profile'
 and select your default profile that you set up in step 2.</li>
 <li>Restart the SQL Server Agent</li>
 </ol>
</blockquote>

blocks|key|1895987|text|我必须授予Server代理对邮件配置文件的访问权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1895988|右键单击中的Server代理节点，然后选择Properties。然后切换到警报系统节点，并启用要允许Server代理使用的邮件配置文件，重新启动Server代理服务|1895989|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had to grant the SQL Server Agent access to the mail profile.

Right click on the SQL Server Agent node in SQL Server Management Studio, and select Properties. Then switch to the Alert System node, and enable the Mail profile you’d like to allow the SQL Server Agent to use, restart the SQL Server Agent Service

blocks|key|2685184|text|在SQL+Server+2014中，这对我起了作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2685185|转到“SQL代理作业”的属性，选择“通知”页面，如果选中“电子邮件”复选框，然后取消勾选，应用该更改。然后回到工作中，重新勾选方框并选择您的操作员，然后再申请。|2685186|​|2685187|📷|atomic|offset|length|2685188|2685189|我认为最初的问题是由于混乱的DbMail配置文件，所以取消连接和重新挂钩的运营商似乎把事情变平了。|2685190|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/7213b8b91d11ee4c9d4e3e7b275b9dae.png|imageAlt^0|0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@$I|10|J|11|1|12]]|A|$]]|$1|K|3|E|5|6|7|13|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U|V|-4]]]]

This worked for me in SQL Server 2014:

Go to the properties of the SQL Agent Job, choose the Notifications page, if the email checkbox is ticked then untick it, apply that change. Then go back into the job and re-tick the box and select your Operator, then apply again.

<a href="https://i.stack.imgur.com/wUQdW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wUQdW.png" alt="enter image description here"></a>

I think the original problem was caused by messing about with the DbMail Profiles, so unhooking and re-hooking the link to the Operator seemed to flatten things back out.

blocks|key|1896065|text|我遵循了下面关于Server+2019的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1896066|第一个解决方案是重新启动Server代理。|1896067|在重新启动Server代理之后，一些SQL服务器仍然面临问题。|1896068|第二个解决方案是->+Server代理属性->+AlertSystem+->“取消启用邮件配置文件”，如果它已经勾选了->，单击OK。再次打开，Server代理属性->+AlertSystem+->“勾选启用邮件配置文件”，单击OK|1896069|对我起作用了。|1896070|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I followed below solutions on SQL Server 2019.
First Solution is restarting the SQL Server Agent.
Some of the SQL Servers are still faced issue after restarted the SQL Server Agent as well.
The second solution is -&gt; SQL Server Agent Properties -&gt; AlertSystem -&gt; &quot;Untick the Enable Mail Profile&quot; if it ticked already -&gt; Click OK. Again open, SQL Server Agent Properties -&gt; AlertSystem -&gt; &quot;Tick the Enable Mail Profile&quot; Click OK
It worked for me.

I have a problem with sending notification when the job fails. I created Database Mail Profile and assigned it to SQL Agent and the restarted SQL Agent.
When I run a procedure <code>msdb.dbo.sp_send_dbmail</code> the e-mail is being sent. Also when I send a test e-mail using Database Mail it works fine. But when I set a notification for Job when it fails, in job log I see following information: NOTE: Failed to notify 'SQL Job Failure' via email.
I don't know what can be the source of this problem. I found this hint: <a href="http://sqlblog.jfperry.com/jpsql/post/2009/04/07/NOTE-Failed-to-notify-7boperator7d-via-email.aspx" rel="noreferrer">http://sqlblog.jfperry.com/jpsql/post/2009/04/07/NOTE-Failed-to-notify-7boperator7d-via-email.aspx</a>

But I checked that the profile is enabled in SQL Agent. SQL Agent has been restarted. Where can be the source of the problem?

Error: NOTE: Failed to notify 'operator' via email. when trying to send e-mail when job fails

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

当作业失败时，我在发送通知时遇到问题。我创建了数据库邮件配置文件，并将其分配给SQL代理和重新启动的SQL代理。当我运行一个过程msdb.dbo.sp_send_dbmail时，电子邮件将被发送。另外，当我使用数据库邮件发送测试电子邮件时，它可以正常工作。但是，当我在作业失败时设置通知时，在作业日志中我会看到以下信息:注意:未能通过电子邮件通知“SQL”。我不知道这个问题的根源是什么。我发现了这个

问错误:注意:未能通过电子邮件通知“操作员”。当工作失败时尝试发送电子邮件时
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问错误:注意:未能通过电子邮件通知“操作员”。当工作失败时尝试发送电子邮件时EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问错误:注意:未能通过电子邮件通知“操作员”。当工作失败时尝试发送电子邮件时
EN