.png)
How to: Resize the Job History Log (SQL Server Management Studio)
This topic describes how to set size limits for Microsoft SQL Server Agent job history logs.
-
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
-
Right-click SQL Server Agent, and then click Properties.
-
Select the History page, and then confirm that Limit size of job history log is checked.
-
In the Maximum job history log size 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.
-
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
-
Right-click SQL Server Agent, and then click Properties.
-
Select the History page, and then click Automatically remove agent history.
-
Select the appropriate number of Days(s), Week(s), or Month(s).
