Configure SQL Server Agent Job History
- Kunal Ranpura
- 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
bottom of page
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=10000,
@jobhistory_max_rows_per_job=1000
Comments