Configure SQL Server Agent Job History
Jul 28, 2019
1 min read
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=10000,
@jobhistory_max_rows_per_job=1000
top of page
Search
bottom of page
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=10000,
@jobhistory_max_rows_per_job=1000
Comments