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.

Azure
Automation Account
[Not supported by viewer]
PowerShell
Workflow Runbook
[Not supported by viewer]
T-SQL
[Not supported by viewer]
Schedules
[Not supported by viewer]
Icon-databases-130 public:true sdk:MsPortalFx.Base.Images.Polychromatic.Database(); MsPortalFx.Base.Images.Polychromatic.SqlDatabase() category: Databases image/svg+xml Icon-databases-130 Icon-322Artboard 1 public:true sdk:MsPortalFx.Base.Images.Polychromatic.Automation() category: Management + Governance image/svg+xml Icon-322Artboard 1 MsPortalFx.base.images-10 public:true sdk: MsPortalFx.Base.Images.Polychromatic.Powershell() category: General image/svg+xml MsPortalFx.base.images-10