Question

Why might a maintenance plan fail to generate a SQL Server job?

SQL Server performance tuning, SQL database

I was reading the article “Use the database maintenance plan wizard” on SearchSQLServer.com and wanted to ask, why in some cases, a maintenance plan would fail to generate a SQL Server job. I currently have cases where a maintenance plan was saved but jobs were not created at all or, in one instance, only the optimizer job was created. Can you explain what would cause this, and should I be worried the maintenance plan might not run completely if a job does not exist for one of the tasks?

If the job doesn't exist then it is definitely something that needs to be looked at. Is the job doesn't exist then that part of the plan will not work.

As to what would cause that, it could be that the job schedule was invalid. Was there any error message when you created the maintenance plan?