在Azure SQL Db数据更改上调用Azure触发器功能 [英] Calling Azure Trigger function on Azure SQL Db data change
问题描述
I have a Azure SQL DB and when data gets inserted in a particular table there I need an Azure function to get automatically triggered. I have looked in the web and could not find any possible solution except using Timer function . However , I do not want the Azure credits to go down by running a function continuously , so i need a different solution. Also ,it seems we wont be able to send http trigger from Azure SQL as it doesn’t support CLR Assemblies,unlike SQL server. Somehow can we track any trigger/data change in Azure Queue... that will also help.
预先感谢您……希望获得具体解决方案.
Thanking you in advance ...hoping to receive concrete solution.
推荐答案
If you are running your function on a consumption plan you will only be charged for the time your function is on and running the process. The function will not stay on continuously until the timer runs again. So you should have no problems running a timer trigger and having your credits ran down.
如果您正在运行 应用服务计划.因此,请确保您正在执行消耗计划,并且应该将其设置为使用计时器功能:)
This is not true if you are running an App Service Plan. So much make sure you are running a consumption plan and you should be set to use a timer function :)
这篇关于在Azure SQL Db数据更改上调用Azure触发器功能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!