Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2006-03-07 : 10:04:23
|
| I am going through the maintenance plan to create a schedules backup.Everything seems fine until the final stages of the backup schedule setup when the system gives the following error.create failed for jobStep SubPlan.p.s I am not sure how to attached a snapshot of the error message.Thanks |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2006-03-08 : 00:09:07
|
| Hi,you can post error message here or you may post snap to some free photo hosting server or your geocities or some free hosting provider ...but error message itself provide a good information for solving your problem. so please post error message too.RegardsAndy DavisSql Shield Team--------------------------------------------SQL Server Encryption Softwarehttp://www.sql-shield.com |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-08 : 00:49:32
|
| what's your step subPlan doing?--------------------keeping it simple... |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2006-03-08 : 02:27:27
|
| This is the error message:Maintenance Plan Wizard Progress- Creating maintenance plan "Dev_BackupPlan" (Error)Messages* 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 statementor batch.(Microsoft.SqlServer.ConnectionInfo)------------------------------The specified '@subsystem' is invalid (valid values are returnedby 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- Adding tasks to the maintenance plan (Stopped)- Adding scheduling options (Stopped)- Adding reporting options (Stopped)- Saving maintenance plan "Dev_BackupPlan" (Stopped) |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-08 : 03:11:07
|
this is your key here but since it's a wizard, how do you troubleshoot...i suggest you create your own backup jobs for easier management  quote:
The specified '@subsystem' is invalid (valid values are returnedby sp_enum_sqlagent_subsystems).(Microsoft SQL Server, Error: 14234)
--------------------keeping it simple... |
|
|
|
|
|
|
backup