How to resize the job history log (Enterprise Manager)
To resize the job history log
- Right-click SQL Server Agent; then click Properties.
- In the SQL Server Agent Properties dialog box, click the Job System tab.
- Select Limit size of job history log.
- In the Maximum job history log size (rows) box, enter the maximum number of rows the job history log should allow.
- 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.