Auto-Creating DB Maint Plans?

[KingSexy182]

Hi Guys,

Does anyone know an easier way to create DB Maint Plans instead of having to create each one manually?
i.e. Copy Maint Plans from 1 server to another automatically.
Does anyone know of a quick export method.

thnx in advance.

[MAK]

here is a hint.

select * from msdb..sysdbmaintplan_databases
select * from msdb..sysdbmaintplan_history
select * from msdb..sysdbmaintplan_jobs
select * from msdb..sysdbmaintplans

[rmiao]

Don't think you can just copy the plan to another server and it works right away. DB name may different for instance.

[Stephen]

As well as the data that is in the sysdbmaint tables, some of the definition of the of the maintenance plan is actually in the related sql agent job(s).

Use profiler to see what enterprise manager does when it gets the properties for a maintenance plan.

[KingSexy182]

thanks guys.
for the sake of sanity, im just gonna create them manually.