April 17, 2012 at 7:30 am
I see some of my sql jobs history clears and I cannot see it,
help is appreciated,
April 17, 2012 at 7:33 am
job history is set to clear out when the history table becomes larger than 1000 rows by default, or if a job exceeds 100 rows.
this can be changed by setting the properties of the history page in sql server agent properties
April 17, 2012 at 7:36 am
right click on sql server agent, properties history, you probably need to increase your retention values, in particular job history log size.
You could also have a purge job running via a maintenance plan cleanup task or a standalone sqlagent job.
---------------------------------------------------------------------
April 17, 2012 at 7:50 am
Thanks a Lot I changed this,
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply