how to schedule a stored procedure in AZURE

Question

I have a stored procedure that I want it to run in every mid nigh but my data base is in aZure

How can I schedule a task using sql agent?

score 7 · Answer 1 · answered Jul 18 '16 at 14:46

7

make a small powershell script and schedule it in the azure dashboard.

answered Jul 18 '16 at 14:46

JP Hellemons

@jaredad7 This it? https://learn.microsoft.com/en-us/azure/automation/automation-starting-a-runbook – Rob Sedgwick Oct 03 '18 at 16:06

score 4 · Answer 2 · answered Sep 17 '15 at 13:08

You can use Azure Web Job and create a console App that just call your stored procedure and schedule it to run every mid night.

Here's a sample of how to use Azure Web Job:

score 0 · Answer 3 · answered Sep 17 '15 at 13:06

0

answered Sep 17 '15 at 13:06

Luckbox72

3 Answers3