插入新记录时发送电子邮件 [英] E-mail when new record is inserted

问题描述

大家好，



当我的Sql Server数据库创建新记录时，是否有人知道如何设置电子邮件通知。我希望能够通过电子邮件将通知发送给负责任的salesrep。在其职责范围内创建销售订单时。所以我还需要为creterias发送电子邮件设置一些规则。



我有一个sql数据库我Azure，我无法访问任何SqlAgent那里？



我尝试了什么：



我还没试过什么，但希望得到一个好主意如何解决它。

Hello everyone,

Does anybody have a good idea how to set up e-mail notifications when a new record is created i my Sql Server Database. I would like to be able to e-mail a notification to the responsible salesrep. when a salesorder is created within his responsibility area. So i also need to have a some rules setup for creterias for sending emails.

I have an sql database i Azure and i don't have access to any SqlAgent from there?

What I have tried:

I have not tried anything yet but hoping to get a good idea how to solve it.

推荐答案

你可以用触发器发送每当插入/更新/删除表格时都会收到电子邮件通知。





请参考此链接：

< a href =http://stackoverflow.com/questions/10755469/send-e-mail-from-a-trigger> sql server 2008 r2 - 从触发器发送电子邮件 - Stack Overflow [< a href =http://stackoverflow.com/questions/10755469/send-e-mail-from-a-triggertarget =_ blanktitle =New Window> ^ ]

you can user triggers to send a email notifications whenever a table gets inserted/updated/deleted.


refer this link:
sql server 2008 r2 - Send e-mail from a trigger - Stack Overflow[^]

这篇关于插入新记录时发送电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！