Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
in Azure by (45.3k points)

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.

1 Answer

0 votes
by (16.8k points)

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:

Browse Categories