CODEWITHSUNDEEP
azureazure-sql-databasesql-job
heymega
heymega

Reputation: 9391

Azure - Schedule SQL Job

I'm in the process of creating a small Azure site consisting of the following

The website supports user accounts and licensing. I plan on handling the licensing checks via a scheduled SQL service (Much like a SQL agent in SQL Server) once a day.

What are my options here?

Upvotes: 0

Views: 147

Answers (1)

Jeroen Maes
Jeroen Maes

Reputation: 673

If you are using an Azure SQL Database (which I assume you are), then you don't have the SQL Server Agent.

You do however have 2 possible options for your needs:

  1. Using Azure Automation, you can use PowerShell to do your scheduled tasks. More info and a sample here. Azure Automation is the surrogate for the SQL Agent if you ask me.
  2. The other option is Azure WebJobs. I think this is the way to go, as you are already using Azure WebSites and this comes as a feature of it. Scott Hanselman has an excellent blog post about it.

Upvotes: 1

Related Questions