Редагувати

FIX: Error may occur when setting the SQL Server Agent job history log

  • Стаття
  • Сфера застосування:
    SQL Server 2022 on Linux, SQL Server 2019 on Linux

Symptoms

Assume that the Microsoft SQL Server Agent is enabled within a SQL Server instance on a Linux installation. When you try to set or change the maximum number of rows for the job history log and the maximum number of job history rows per job, the following error may occur:

Msg 0, Level 11, State 0, Line <LineNumber>
A severe error occurred on the current command. The results, if any, should be discarded.

Resolution

Two new SQL Server Agent properties, sqlagent.jobhistorymaxrows and sqlagent.jobhistorymaxrowsperjob, have been added to the mssql-conf configuration utility. These settings allow you to set the maximum number of rows for the job history log and the maximum number of job history rows per job, respectively.

Example:
sudo /opt/mssql/bin/mssql-conf set sqlagent.jobhistorymaxrows 1000
sudo /opt/mssql/bin/mssql-conf set sqlagent.jobhistorymaxrowsperjob 100

Note

The two properties can't be configured by using SQL Server Management Studio (SSMS).

This problem is fixed in the following cumulative updates for SQL Server:

About cumulative updates for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for your version of SQL Server:

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology that Microsoft uses to describe software updates.