SQL Agent – job history set number of rows July 2, 2008 9:23 am \ by John Perry USE [msdb]GOEXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=200000, @jobhistory_max_rows_per_job=10000GO Posted in: Uncategorized