question

$$ANON_USER$$ avatar image
1 Vote"
$$ANON_USER$$ asked Reut-0534 answered

How to change SQL Agent Job history limits on Linux?

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.






sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Have you tried logging into SSMS and connecting with the 'sa' account?

0 Votes 0 ·

Yes, everything I tried was done on 'sa' account.

0 Votes 0 ·
Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered AndrejLucansky-9352 edited

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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi anonymous user,
Is there any update on this case?

0 Votes 0 ·

Hi @Criszhan-msft,

Thanks for the link. Yes, I'm on latest CU of SQL Server 2019. No progress, still does not work.

1 Vote 1 ·
Reut-0534 avatar image
0 Votes"
Reut-0534 answered

people ask about this in other forums as well:

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.