Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 490
  • Last Modified:

scheduling a stored procedure in azue sql server

I have a stored procedure that I created in an Azure sql server database which I would like to schedule to run monthly.  When I use the Microsoft sql server management studio on my local pc and connect to the azure database there is no "sql server agent".  I looked in the Azure portal to see if there was a way to schedule a job and could not figure it out.  Can someone help me?
0
kw66722
Asked:
kw66722
2 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm not an Azure Expert but I think there's no SQL Agent for Azure. Instead they have a service called Azure Automation but to be honest with you I never used it.
0
 
Pawan KumarDatabase ExpertCommented:
Hi,
There are multiple ways to achieve this. Choose depending on your requirement.

Run Background tasks with WebJobs
<<https://docs.microsoft.com/en-us/azure/app-service-web/web-sites-create-web-jobs>>

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

Scheduling job on SQL Azure via mobile service
<<https://blogs.msdn.microsoft.com/ms-tech_learning_with_prasant/2014/07/09/scheduling-job-on-sql-azure/>>

Hope it helps !!
0
 
kw66722Author Commented:
From the information I was able to come up with a solution,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now