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