SQL Server CTP 16 - Failure to set maintenance plan

SQL Server CTP 16 - Failure to set maintenance plan

• Lee Coward

  Maintenance plans need that you install SSIS (Sql Server Integration Services) on the server on which you are trying to create the maintenance plan. If you havent installed that, you may do so by running setup again and choosing to install integration services.
  
  Do let me know if that works for you.
  
  -nimesh
  nimeshn@msn.com
  

• Helen Feddema

  I dont know why you dont find it. I do find it in the msdb database. If you are using SSMS, then you can set a filter under the stored procs node under the msdb system database.
  
  Hope that helps
  -nimesh
  

• Pimenta

  This solution worked for us as well.
  
  Thanks for the pointer as it would have taken quite a while to figure this out otherwise.  I wondered during install what SSIS was needed for, and now I know.  The obscure message reported by this first error that we encountered leaves me concerned about what else we might run into.  Good thing this forum was there to help.
  
  Note that the error message complains "The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems)."  When I try to run sp_enum_sqlagent_subsystems it is not found, nor is it in sysObjects, even after installing SSIS.  I don't need to run it now, but am still curious why it is not found.
  

• Ben Jackson

  Looks like this is the same issue in RTM. Could have been a more clear error or checking up front.
  
  Create maintenance plan failed.

  ------------------------------
  ADDITIONAL INFORMATION:

  Create failed for JobStep 'Subplan'.  (Microsoft.SqlServer.MaintenancePlanTasks)

  For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476

  ------------------------------

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)

  For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476

  
  

• robatdural

  This solution worked in our environment
  

• GavinWu

  We're also using the SQL Server September CTP and running into the same error using the Maintenance Plan wizard.  If we try to create a Maintenance Plan to do backups without the wizard, the following error pops up when trying to save the plan:
  
  Create failed for Job "MaintenancePlan"
  
  I would also like to know if anyone has been able to create a Maintenance Plan for backups successfully.
  

• N.I.C.

  Works fine here too! Great! Thanks for the tip.
  
  
• SQL Server CTP 16 - Failure to set maintenance plan