Mrdenny 
46795 pts. | May 23 2008 5:12PM GMT
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
Q:
Why might a maintenance plan fail to generate a SQL Server job?
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?
ASKED:
Apr 28 2008 3:34 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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?
