tigertoolbox
tigertoolbox copied to clipboard
Guidance on running `3_job_AdaptiveIndexDefrag` on Azure SQL
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?