CODEWITHSUNDEEP
cronazure-sql-database
Taras Kovalenko
Taras Kovalenko

Reputation: 2393

Azure SQL procedure add in schedulers

I've got the Azure SQL procedure for migrating data from table A to table B. And I need to run this procedure at 15 min intervals. I thought I could use Azure webjob for it, but I don't know how to call my azure sql procedure. Are there any available schedulers in azure sql or how is it possible to make add Azure sql procedure to the Azure scheduler?

Upvotes: 0

Views: 93

Answers (1)

elfisher
elfisher

Reputation: 1230

One option for scheduling Azure SQL Database stored procedures would be to leverage Azure Automation. There is a blog post which explains how to run TSQL with Azure Automation here. Azure Automation has a scheduler built in, however if it doesn't meet your needs, you could leverage Azure Scheduler to schedule the Automation Runbook instead.

Upvotes: 1

Related Questions