Stored Procedures to change options in Maintenace Plans

• lindss01

  SSCrazy

  Points: 2264

  More actions

  November 12, 2004 at 8:50 am

  #60649

  We use Mainteance Plans to manage our backups.  There are options on the reporting tab in Enterprise Manager that I can not find a stored procedure that I can use to change.  Specifically, I am looking to code changes to the "History on this Server" section.  Currently we take defaults and they are not working for us.

  Anybody know how to change Limit the rows stored in the table sysdbmaintplan_history via stored procedures?

   

  Thanks

  Steve

   

   

• wz700

  SSCertifiable

  Points: 7133

  More actions

  November 14, 2004 at 9:18 pm

  #530070

  The default value is in registry

  HKEY_LOCAL_MACHINE

    SOFTWARE

      Microsoft

        MSSQLServer

          SQLServerAgent

            JobHistoryMaxRows

  A trace in Maintenance job indicates msdb.dbo.sysdbmaintplans is the table to change.