Hi there

I 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