Monthly Archives: July 2008

You are browsing the site archives by month.

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

Posted in: Uncategorized