Home > IT Answers > SQL Server > Why might a maintenance plan fail to generate a SQL Server job?
SQL Server Ask the Experts
2,585 pts.
 Why might a maintenance plan fail to generate a SQL Server job?
SQL Database, SQL Server performance tuning
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
RELATED QUESTIONS
Answer Wiki:
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?
Last Wiki Answer Submitted:  May 23, 2008  5:12 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.