CODEWITHSUNDEEP
azureazure-sql-databaseazure-mobile-servicessql-scripts
TimQ
TimQ

Reputation: 11

Windows Azure SQL Scripting

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.

Upvotes: 1

Views: 77

Answers (1)

Joseph Idziorek
Joseph Idziorek

Reputation: 5071

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.

Upvotes: 2

Related Questions