Edit

SQL Server Agent Properties (History Page)

  • Article

Applies to: SQL Server Azure SQL Managed Instance

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

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

Options

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.

See Also

SQL Server Agent Error Log