1

I am in the process of creating a simple script for a Windows Azure Hosted Database, that will change the value of one column in one table. The script needs to be scheduled to run every 24 hours. Pretty basic stuff I would have thought.

However my complications start with the fact that I cannot create a stored Procedure in SQL. All my research has told me to create a Mobile Service with Azure which I have done but being a novice I am unsure of the approach in terms of configuration or syntax. I am now unsure whether this is even the right approach

I can also see a new Login created for my SQL database when I connect using SSMS. I presume I have to give this login permission somehow.

If anyone is able to point me in the right direction I would be grateful.

Improve this question
3
  • Show your approaches Commented Jun 3, 2015 at 16:29
  • Does a scheduled job in Windows or SQLServer solve the problem? Why can't you create stored procs? If you can't, how bout just using a paramterized query instead? Commented Jun 3, 2015 at 16:34
  • Please take a look at scheduler. Mobile Services is not the right tech for this. azure.microsoft.com/en-us/services/scheduler Commented Jun 3, 2015 at 17:06

1 Answer 1

Reset to default
2

Please see the following blog and example code. Because SQL Agent is not an option in Azure SQL Database, Azure Automation is a great way to schedule jobs against a SQL Database.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Hi,Thank you all very much for the replies.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.