How to resize the job history log (Enterprise Manager)
To resize the job history log
- Expand a server group, and then expand a server.
- Expand Management, right-click SQL Server Agent, and then click Properties.
- Click the Job System tab, and then select Limit size of job history log check box.
- 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.