tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

Guidance on running `3_job_AdaptiveIndexDefrag` on Azure SQL

Open evilpilaf opened this issue 1 year ago • 0 comments

Trying to understand how to run 3_job_AdaptiveIndexDefrag.sql in an AzureSQL database is unclear, the only guidance in the scripts is on the usp_AdaptiveIndexDefrag.sql and it just says:

-- If you are using AdaptiveIndexDefrag together with the maintenance plans in http://blogs.msdn.com/b/blogdoezequiel/archive/2012/09/18/about-maintenance-plans-grooming-sql-server.aspx -- please note that the job that runs AdaptiveIndexDefrag is expecting msdb. As such, change the database context accordingly.

But what is the context? what about the tables that don't exist in AzureSQL? tables and views like dbo.sysjobs don't exist so how are jobs managed and created?

evilpilaf avatar May 31 '23 12:05 evilpilaf