Is it possible to set job history size limits on SQL Server running on Linux? I cannot do it using the UI in SSMS (as described in SQL Server docs), it returns an error when I try to apply changes.
Calling SP msdb.dbo.sp_set_sqlagent_properties also does not work on Linux, it returns
A severe error occurred on the current command. The results, if any, should be discarded.
I also tried looking at mssql-conf in documentation of SQL Server for Linux here, but I did not find any mention of history retention there.
Any help would be much appreciated, default limit of history log size is 1000 rows, so I cannot even see 2 whole days of job executions right now.