How to resize the job history log (Enterprise Manager)

How to Install SQL Server 2000

How To

How to resize the job history log (Enterprise Manager)

To resize the job history log

  1. Expand a server group, and then expand a server.

  2. Expand Management, right-click SQL Server Agent, and then click Properties.

  3. Click the Job System tab, and then select Limit size of job history log check box.

  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.