How to change SQL Agent Job history limits on Linux?

Question

Hi everyone,

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.

Answer 1

Hi anonymous user,

As you can see, we cannot find the job history options in the mssql-conf documentation. It seems that this configuration option for SQL Agent is not enabled on Linux at this time. Also please try to install the latest CU for your sql server instance and test again.

I can see people reported this question on the Microsoft feedback site—This site will serve as a connecting point between you and Microsoft.
https://feedback.azure.com/forums/908035-sql-server/suggestions/38614984-sql-server-2017-on-ubuntu-linux-agent-history-si

you can vote and comment on this post to make your voice heard.

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

people ask about this in other forums as well:

sql-agent-job-history-limits-on-linux