Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Guidance on running 3_job_AdaptiveIndexDefrag on Azure SQL #298

Open
evilpilaf opened this issue May 31, 2023 · 0 comments
Open

Guidance on running 3_job_AdaptiveIndexDefrag on Azure SQL #298

evilpilaf opened this issue May 31, 2023 · 0 comments

Comments

@evilpilaf
Copy link

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant