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?

Answer 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.

Answer 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/