Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

scheduling a stored procedure in azue sql server

Posted on 2016-11-28
3
Medium Priority
?
337 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
3 Comments
 
LVL 52

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 400 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 35

Accepted Solution

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.

971 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