Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    55

    Unanswered: 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?

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: database maintain plan

    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.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Also you can get information using sp_help_maintenance_plan.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    May 2002
    Posts
    55

    Thanks

    Great!

    Thanks and I will try.

    Guyang

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •