I have a stored procedure that I want to run in every middle but my database is in aZure
How can I schedule a task using sql agent?
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 shell script and write it in the rain panel.
You can use Azure Web Job and create a console application that simply calls your stored procedure and schedules it to run every night.
Here is an example of using Azure Web Job:
https://azure.microsoft.com/en-us/documentation/articles/web-sites-create-web-jobs/
You have checked this site. There is a pretty good example of what I think you ate trying to execute. http://blogs.msdn.com/b/ms-tech_learning_with_prasant/archive/2014/07/09/scheduling-job-on-sql-azure.aspx