Scheduling a stored proc

Hi Dave

Considering you are hosting a .NET application with a SQL database on the Basic Pricing Tier, your best options for scheduling a stored procedure to run every night are:

1. SQL Server Agent Job: This is a built-in feature of SQL Server that allows you to schedule and automate various tasks, including running stored procedures at specific intervals. However, it's important to note that the SQL Server Agent is not available in the Basic pricing tier of Azure SQL Database. It is only available in higher tiers like Standard and Premium.

2. Azure Logic Apps: Logic Apps is a cloud-based service provided by Azure that enables you to create workflows and integrate different systems and services. With Logic Apps, you can schedule the execution of a stored procedure by creating a workflow that triggers at a specific time every night. Logic Apps can be a good option as it is available in the Basic pricing tier and provides flexibility in defining workflows and integrating with other services.

3. Azure Functions: Azure Functions is a serverless compute service that allows you to run event-triggered code without worrying about infrastructure management. You can create a time-triggered Azure Function that executes your stored procedure at the desired schedule. Azure Functions can be a cost-effective option, especially if your stored procedure has lightweight execution requirements. However, keep in mind that the Basic pricing tier has some limitations on the maximum execution time and resource allocation for Azure Functions.

Considering your Basic Pricing Tier, Azure Logic Apps would likely be your best option for scheduling the stored procedure to run every night. It provides a user-friendly interface for workflow creation and integrates well with Azure SQL Database.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mohamed Azarudeen Z3y ago
Accepted answer
Hi Dave

Considering you are hosting a .NET application with a SQL database on the Basic Pricing Tier, your best options for scheduling a stored procedure to run every night are:

1. SQL Server Agent Job: This is a built-in feature of SQL Server that allows you to schedule and automate various tasks, including running stored procedures at specific intervals. However, it's important to note that the SQL Server Agent is not available in the Basic pricing tier of Azure SQL Database. It is only available in higher tiers like Standard and Premium.

2. Azure Logic Apps: Logic Apps is a cloud-based service provided by Azure that enables you to create workflows and integrate different systems and services. With Logic Apps, you can schedule the execution of a stored procedure by creating a workflow that triggers at a specific time every night. Logic Apps can be a good option as it is available in the Basic pricing tier and provides flexibility in defining workflows and integrating with other services.

3. Azure Functions: Azure Functions is a serverless compute service that allows you to run event-triggered code without worrying about infrastructure management. You can create a time-triggered Azure Function that executes your stored procedure at the desired schedule. Azure Functions can be a cost-effective option, especially if your stored procedure has lightweight execution requirements. However, keep in mind that the Basic pricing tier has some limitations on the maximum execution time and resource allocation for Azure Functions.

Considering your Basic Pricing Tier, Azure Logic Apps would likely be your best option for scheduling the stored procedure to run every night. It provides a user-friendly interface for workflow creation and integrates well with Azure SQL Database.
+2