Azure Automation - Call Stored Procedure in Azure SQL Periodically
2022-01-22 azurecloud-computing
This diagram shows the idea of using Azure Automation PowerShell Workflow runbook to call a stored procedure or execute other T-SQL in a Azure SQL database. For Kontext, this mechanism is used to regularly update tag, user, site and other stats.