Is there a limit to the number of rows that are stored in job history?
 I see where the Maintenance Plan history can be set, but not for the
 individual jobs. I have set up a test job and run it over 100 times, but
 there seems to be a limit of 100 entries in the sysjobhistory table.
 Is this correct and if it is, where is that documented?
 Thanks,
 WillNever Mind - I see that the setting is in the SQL Server Agent properties.
"Will Winn" wrote:
> Is there a limit to the number of rows that are stored in job history?
> I see where the Maintenance Plan history can be set, but not for the
> individual jobs. I have set up a test job and run it over 100 times, but
> there seems to be a limit of 100 entries in the sysjobhistory table.
> Is this correct and if it is, where is that documented?
> Thanks,
> Will
 
No comments:
Post a Comment