Post reply

Maintenance Plan fails

  • February 13, 2006 at 8:42 am

    #116151

    I attempted to set up a maintenance plan and got the below error regarding a failed subplan. Any suggestions?

    Thanks...Nali

    ===================================

    Create maintenance plan failed.

    ===================================

    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

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

    Program Location:

       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan.AddAgentJob(ServerConnection localConnObj, String proxyName)

       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlanSubPlan..ctor(String subplanName, String proxyAccount, Package package, ServerConnection localConnObj)

       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.AddSubPlan(String subplanName, String proxyAccount)

       at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()

    ===================================

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

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

    Program Location:

       at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

       at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

       at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)

       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so)

       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()

    ===================================

    The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (.Net SqlClient Data Provider)

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

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

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

    Server Name: ServerName\INSTANCE200501

    Error Number: 14234

    Severity: 16

    State: 1

    Procedure: sp_verify_subsystem

    Line Number: 28

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

    Program Location:

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

       at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

  • February 13, 2006 at 9:09 am

    #620466

    Do you have Integration Services installed?  I ran into a similar problem that was corrected once I installed

    integration services.

     

  • February 13, 2006 at 9:39 am

    #620474

    That worked! Thanks!

  • February 13, 2006 at 11:02 am

    #620495

    What are Integeration Services, Please guide me how and from where I can install these services.

    Tell me if there is any bad effect on the Database users and response.

    Thanx.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply