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?
Software/Hardware used:
ASKED:
April 28, 2008 3:34 PM
UPDATED:
May 23, 2008 5:12 PM
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.