SQL Agent – job history set number of rows

USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties
@jobhistory_max_rows=200000,
@jobhistory_max_rows_per_job=10000
GO

Comments are closed.

Post Navigation