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?

Solution 1

Azure Automation: Your SQL Agent in the Cloud: https://azure.microsoft.com/en-us/blog/azure-automation-your-sql-agent-in-the-cloud/

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

Solution 2

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:

https://azure.microsoft.com/en-us/documentation/articles/web-sites-create-web-jobs/

Comments

[Rob Sedgwick]

@jaredad7 This it? docs.microsoft.com/en-us/azure/automation/…