Wednesday, March 7, 2012

database maintain plan

using database maintain plan to do the backup/reindex , etc.
where can I find the plan information inside database ( ex. xp_sqlmaint N'-PlanID) , my question is where the plan stored?hi,
all the maintainance plan info is saved in the database msdb.
check the tables: sysdbmaintplan_databases
sysdbmaintplan_history
sysdbmaintplans
sysdbmaintplan_jobs

For more details refere BOL.
Regards,
Harshal.|||Also you can get information using sp_help_maintenance_plan.|||Great!

Thanks and I will try.

Guyang

No comments:

Post a Comment