BCLynch (10/8/2008)
Hi thereI took a maintenance plan (conencted to SSIS) end exported it to a file. I connected to a clean sql server and imported the dtsx file.
This created the maintenance plan object, but it did not create any of the related jobs under SQL agent.
Upon looking at the maintenance plan I could see each of the subtasks marked as unshceduled.
I manually rescheduled one of the tasks and magically all the agents jobs now reappeared. None of the other tasks changed from unshceduled
My questions are
Why did the jobs magically appear only when I manually rescheduled one of them/
How can I relink the jobs created by importing the dtsx maintenance plan to its jobs?
and
Why is all of this such a pain in the ***?
Thanks
Barry
I wish I knew the answer to your questions. As to why it is such a pain I think this is a black hole in DR procedures microsoft didn't see ( or would not acknowledge) when SSIS was used for maintenance plans and SSIS seperated out to use the BIDS interface. We production DBAs always seem to get the dirty end of the stick.
It is sad there are no MS whitepapers on the subject of migrating the msdb database (that I can find). mind you, I'm not sure the SQL2000 quick fix of updating sysjobs.originating_server was advertised on official MS sites.
End of Rant.
---------------------------------------------------------------------