Solved

scheduling a stored procedure in azue sql server

Posted on 2016-11-28
3
121 Views
Last Modified: 2016-12-21
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
Comment
Question by:kw66722
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 50

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 100 total points
ID: 41905290
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
 
LVL 28

Accepted Solution

by:
Pawan Kumar earned 400 total points
ID: 41905295
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
 
LVL 1

Author Comment

by:kw66722
ID: 41906338
From the information I was able to come up with a solution,
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Optimized for private cloud infrastructures and datacenters, Nano Server is minimalistic, yet super-efficient, OS for services such as Hyper-V and Hyper-V cluster. Learn how you can easily deploy Nano Server and unlock its power!
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question