September 18, 2009 at 9:40 am
Hi,
Please advise on how to overcome the limited number of 100 records when querying sysjobhistory
Any information helping to understand the cause of this limitation is highly appreciated as well.
Thanks,
Mike Gouders
September 18, 2009 at 9:53 am
Could it be that is all the data in your sysjobhistory table?
The default for a given job is 100.
You can configure the amount of history that the SQL Server Agent will keep. In SQL Server 2005 go to SQL Server Agent, right click and choose properties. You can then define the retention limits on the history page.
September 18, 2009 at 10:45 am
Thank you ,
That was perfect knowledge transfer 🙂
Mike
September 18, 2009 at 12:25 pm
Glad to help Mike!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply