Configure SQL Agent History on Linux

Highlighted
Occasional Contributor

SQL Server Agent History stores only 1000 rows in total and 100 row per job. I need to increase this value on SQL Server on Linux.

On changing this configuration on SSMS, the error "A severe error occurred on the current command" is shown. Investigating, this configuration is on the Windows Registry.

 

How to keep more agent history on SQL Server on Linux?

Microsoft SQL Server 2017 (RTM-CU5) (KB4092643) - 14.0.3023.8 (X64)   Mar  2 2018 18:24:44   Copyright (C) 2017 Microsoft Corporation  Web Edition (64-bit) on Linux (Ubuntu 16.04.5 LTS)

0 Replies