Azure Sql Server电子邮件方法 [英] Azure Sql server Email approach

问题描述

从Azure SQL Server发送电子邮件的最佳方法是什么.由于SQL Server代理不在Azure Sql中，因此如何发送DBmail.我们正在迁移数据库或将数据库迁移到Azure SQL Server，之前的邮件是从SQL Server的DB Mail服务器发送的.邮件 需要在SSIS程序包运行后立即发送.当前，我已经在Azure SQL中创建了表，该表将包含所有队列电子邮件，已经创建了Azure函数，该表将发送队列电子邮件.但是由于我创建了计时器触发器，因此这种方法被延迟了， 将记录插入电子邮件队列表"后，是否还有其他更好的方法来发送电子邮件. Thankyou

what is the best approach to send emails from Azure SQL Server. As SQL Server Agent is not in Azure Sql, then how the DBmail is sent. We are migrating or DB to Azure SQL Server, earlier the mails were sent from DB Mail server from SQL Server. The mails need to be send as soon the SSIS package is run, Currently I have created the table in Azure SQL which will have all queue emails, I have created the Azure function which will send the queue emails. But this approach is delayed as I have created Timer Trigger, Is there any other better approch to send the emails as soon as the record is inserted in Email Queue Table. Thankyou

推荐答案

以下是您已采用的解决方案的解决方法:

Here is a workaround to the solution you already have in place:

https://vpolizzi.wordpress.com/2010/09/11/database-mail-on-sql-azure/

这篇关于Azure Sql Server电子邮件方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！