Home Forums SQL Server 7,2000 Administration How to script existing DB Maintenance Plans RE: How to script existing DB Maintenance Plans
tosscrosby
SSCoach
Points: 18045
More actions
May 28, 2008 at 8:45 am
#821224
You will have to update the table sysjobs in msdb. The field is originating_server and should reflect the new server name. I've done this in the past without issue.
Edit - This is for S2K.
-- You can't be late until you show up.