February 17, 2023 at 8:25 am
Dear Friends,
Would highly appreciate if you can help with the setting I have to perform to let SQL server agent retain a Job's history. I am given custody of some SQL servers in which one of them doesn't have the Job history, though the Jobs execute well.I checked the properties of the 'SQL Server Agent' to see if I find something where the Remove history option is 'Unchecked' but still there is no history of the Jobs.. Thank you in advance.
February 17, 2023 at 10:24 am
On that same properties area is the "Size of job log" and "number of rows per job".
Are these set at the default 1000 / 100?
How many jobs do you have? What is the frequency of them running?
If you have multiple jobs running very fast then this 1000 row limit will purge older records out for ALL jobs not just the job(s) that run very frequently to keep the history tables small.
February 17, 2023 at 1:45 pm
@Ant-green
The setting is 1000 and 100 respectively. Interestingly a newly instance I recently setup on the same server , (with both having identical settings above ),writes the history. More interesting is the fact that this server (the one has no log history for DBCC jobs) has all the other jobs (log shipping) writing the logs well but doesn't it only for DBCC. The purging can be ruled out as the interval of running the LSBackup jobs is 60 minutes , the least on the Databases under log shipping. Thank you in advance.
February 17, 2023 at 3:32 pm
The setting is 1000 and 100 respectively.
You REALLY need to change that ASAP.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply