June 2, 2010 at 7:24 pm
I imported the maintenance plan package from one server to another, everythink looked ok except for the jobs were missing.
How will the jobs automatically get created?
Thanks everyone.
June 2, 2010 at 7:44 pm
First, importing maintenance plans directly from one system to the other will not work. The plan will be created, but the local connection will be set to the other server. When you try to run that plan - it will actually run on the other system.
Second, the agent jobs are created when you modify the plan on the new server and save it. You'll have to do this anyways, because the schedule is not copied when you import.
Finally, to do what you want to do - you can do the following:
1) Create a new SSIS project in BIDS
2) Import the maintenance plans into this project from the old server
3) Modify the local connection to the new server
4) Modify the databases for each task, the file locations, etc...
5) Go to File | Save Copy As - and save the maintenance plan to the new server
6) Open the maintenance plan on the new server - verify the settings (e.g. databases, folders, etc...)
7) Create the schedule and save the plan
Note: Do not try to add or remove any tasks from the plan. Don't mess with the reporting tasks or try to modify any of the properties or add SSIS tasks to the plan. This will break the plan and you won't be able to remove it without deleting from the tables directly - which can break even more things.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply