July 19, 2010 at 9:50 am
We have a SQL 2008 job server that we use to push jobs to 2005 and 2008 SQL servers.
All jobs that contain T-SQL statements only work fine for both SQL versions, but maintenance plans (optimization, integrity, etc) will not push out to the 2005 SP3 servers. The distributed maintenance plans appear on the 2008 target servers but not on the 2005 ones.
The error message on the target servers state:
'Failed to import Maintenance Plan <PlanName> from <Job Server>...Could not find stored procedure 'msdb.dbo.sp_dts_getfolder' "
We have tried creating the jobs using both 2005 and 2008 but this has made no difference.
Any help would be appreciated.
July 19, 2010 at 12:37 pm
Likely there is some 2008 task that will not run on 2005. You probably cannot do this as you are going downlevel and sending something to the 2005 server that did not exist when it was built.
I would set up a 2005 server to manage 2005 plans separately.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply