How to resize the job history log (Enterprise Manager)

To resize the job history log

  1. Right-click SQL Server Agent; then click Properties.
  2. In the SQL Server Agent Properties dialog box, click the Job System tab.
  3. Select Limit size of job history log.
  4. In the Maximum job history log size (rows) box, enter the maximum number of rows the job history log should allow.
  5. In the Maximum job history rows per job box, enter the maximum number of job history rows to allow for a job.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.