Best way to Schedule Sql job in Microsoft Azure?

Question

I have one SQL job which actually checks fragmentation % in DB of all the indexes and Rebuilds indexes if required. Which is running well in my Testing server Microsoft SQL Server 2012. But my production server is in Azure. Now I want to schedule that job to Azure. How can I schedule a SQL Job in Azure Db? I am new to Azure.

Answer 1

Basically, Microsoft Azure SQL DB does not support any SQL Server Agent or jobs.

No doubt, you can easily run SQL Server Agent on-premise SQL Server and then connect it to Microsoft Azure SQL DB, this should work.

Know more about webjobs and Scheduling Jobs on Azure by following these articles by microsoft:

https://docs.microsoft.com/en-us/azure/app-service/webjobs-create#CreateScheduled

https://blogs.msdn.microsoft.com/ms-tech_learning_with_prasant/2014/07/09/scheduling-job-on-sql-azure/