Solved

scheduling a stored procedure in azue sql server

Posted on 2016-11-28
3
18 Views
Last Modified: 2016-11-29
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
3 Comments
 
LVL 45

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 17

Accepted Solution

by:
Pawan Kumar Khowal 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now