Environment:
SQL Server 2019 CU10 on RHEL 8.4
Issue:
When trying to set the History property of Maximum job history log size (in rows), either through SSMS or direct "EXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=5000", the server returns an error:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
and the property is never set.
I have checked to make sure that mssql user and group are applied to /var/opt/mssql and below (including .system)
I have run the sp both as a regular user and sa with no difference.
The properties can be "read" correctly, just not set. so it appears the "registry" is working ok (or I am getting default values).
Anyone else see this issue or know how to fix it?
Thanks,
Ken