Showing posts with label inside. Show all posts
Showing posts with label inside. Show all posts

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