• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • 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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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