Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

SQL Server Agent Properties (History Page)

 

Use this page to view and modify settings for managing the Microsoft SQL Server Agent service history log.

Limit size of job history log

Sets limits for the amount of job history information that SQL Server Agent retains in the log.

Maximum job history log size (in rows)

Sets the maximum number of rows that SQL Server Agent retains. When the log grows to contain this number of rows, SQL Server Agent removes the oldest rows in the log as new rows are entered.

Maximum job history rows per job

Sets the maximum number of rows that SQL Server Agent retains per job. When the history for a particular job grows to contain this number of rows, SQL Server Agent removes the oldest rows in the log as new rows are entered.

Remove agent history

Specifies that SQL Server Agent will remove entries that have been in the log longer than a specified length of time. This is a one-time execution to remove the history. If a reoccurring job is needed, create and schedule a maintenance plan with a cleanup job.

Older than

Sets the amount of time that SQL Server Agent will retain entries.

Community Additions

ADD
Show:
© 2015 Microsoft