如何在Azure SQL数据库上配置邮件 [英] How to configure mail on Azure SQL Database

问题描述

我们正在从Microsoft SQL Server 2012（SP1）-11.0.3128.0（X64）
迁移到
Microsoft SQL Azure（RTM）-12.0.2000.8

We are moving from Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) to Microsoft SQL Azure (RTM) - 12.0.2000.8

以前，如果特定表在特定时间间隔内未更新，我们会从数据库邮件发送邮件。

Previously we send mail from database mail if a particular table have not updated in a particular time interval.

但是我尝试在Azure邮件上执行相同操作

But i tried to do the same on Azure mail but seems like this functionality is not available on this.

推荐答案

您可以编写存储过程来查询表并返回结果，在Azure WebJob，Logic App或Azure Function中读取结果，安排执行时间并通过电子邮件发送结果。 此处使用Logic App和在这里，您可以找到如何安排它。

You can write a Stored Procedure to query the table and return results, read the results in an Azure WebJob, Logic App or Azure Function, schedule the execution and send the results via email. Here you can find an example using a Logic App and here you can find how to schedule it.

您可以使用自己的Exchange / SMTP服务器，也可以选择使用SendGrid发送如图所示的电子邮件此处。

You can use your own Exchange/SMTP server or you can choose to use SendGrid to send out the email as shown here.

这篇关于如何在Azure SQL数据库上配置邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！