Configure SQL Server Agent Properties

[SQLDBAWithoutABeard]

How do I use SQL Server DSC to configure Agent Properties please? In particular, I'd like to use it to disable 'Limit size of job history log' (SQL Server Agent Properties | History). This is the SQL to do the same:

USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=-1,
@jobhistory_max_rows_per_job=-1
GO

Many thanks

[johlju]

There are no resource yet for this. Please send in a PR with a new resource, suggested name 'SqlAgentSettings`.

It is probably the properties MaximumHistoryRows and MaximumJobHistoryRows from the class JobServer.

Can probably re-use code from the DSC Resource SqlAgentAlert that uses the same class.

[johlju]

Submitted issue #1981 to track this. Closing this in favor of the new issue since it is using the correct issue template for a new resource.

@SQLDBAWithoutABeard Please consider sending in a PR to resolve issue #1981.

[johlju]

@SQLDBAWithoutABeard you should also be able to use SqlScript och SqlScriptQuery using T-SQL to configure this. See documentation for those DSC resources.

[SQLDBAWithoutABeard]

Thanks for your prompt response -sqlscript worked perfectly!