title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.custom | ms.topic | helpviewer_keywords | monikerRange | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Resize the Job History Log |
Resize the Job History Log |
markingmyname |
maghan |
randolphwest |
05/09/2022 |
sql |
ssms |
linux-related-content |
how-to |
|
= azuresqldb-mi-current || >= sql-server-2016 |
[!INCLUDEapplies-to-version/_ssnoversion.md]
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.
This article describes how to set size limits for [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Agent job history logs by using SQL Server Management Studio.
This feature doesn't work for [!INCLUDEsqlonlinux-md].
For detailed information, see Implement SQL Server Agent Security.
-
In Object Explorer, connect to an instance of the [!INCLUDEssDEnoversion], and then expand that instance.
-
Right-click SQL Server Agent, and then select 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 [!INCLUDEssDEnoversion], and then expand that instance.
-
Right-click SQL Server Agent, and then select Properties.
-
Select the History page, and then select Remove agent history.
-
Select the appropriate number of Days, Weeks, or Months.