Oct 03 2018 06:51 AM
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)