SQL SERVER 2005数据库备份排程出错
我在做一个数据库备份排程时,老是出错!
错误信息是:
Create   maintenance   plan   failed.
Additional   information:
Create   failed   for   JobStep   'Subplan '.(Micorsoft   SqlServer.MaintenancePlanTasks)
    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)


我安装的版本是:Microsoft   SQL   Server   2005   -   9.00.2047.00   (X64)       Apr   14   2006   01:11:53       Copyright   (c)   1988-2005   Microsoft   Corporation     Enterprise   Edition   (64-bit)   on   Windows   NT   5.2   (Build   3790:   Service   Pack   2)


------解决方案--------------------
是你的sql语句中的变量@@subsystem引用无效，最好把你的整个sql贴出来