How schedule a SQL Query to run every day on Azure?

Question

Hello.

I'm using the Azure services and I have a query stored as a procedure in SQL Server. I would like to run this procedure automatically everyday. What would be the best approach to achieve that with Azure services?

Thanks in advance.

Answer 1

The best approach to run a SQL Server stored procedure automatically every day in Azure is to use Azure Automation and runbooks. You can create a runbook with a SQL script that will execute the stored procedure. Then you can create a schedule for the runbook to run daily.

Alternatively, you can use Azure Functions with a Timer Trigger to execute the stored procedure daily. You can write an Azure Function in your preferred language (C#, Java, Python, etc.) that executes the stored procedure and configure the Timer Trigger to run daily. You can also use Azure Logic Apps to achieve this.

Answer 2

Adding to the answer provided by Nitish, here you will find a step-by-step procedure to automate execution of a T-SQL stored procedure using Azure Automation.

Answer 3

You can also use a pipeline with the activity "Storage Procedure", then you can just schedule that pipeline for your needs. (On Azure Data Factory)