There are some settings for log size / retention / count, see
https://video2.skills-academy.com/en-us/sql/ssms/agent/resize-the-job-history-log?view=sql-server-ver16
SSMS Log File Summary only shows one day log
KK
1
Reputation point
Hello,
My job history only shows one day data. How can I change this to view all of the log file summary? I have checked the filters but there isn't any filters applied. I have also ran the sysjobhistory and sysjobstepslogs queries but it only has one day data there. Therefore I know there's some setting that is making it to only store only one day's data as other jobs in the same system has more than one day data stored in its job history. Please do help to assist! Thank you!
1 answer
Sort by: Most helpful
-
Olaf Helper 44,501 Reputation points
2022-12-08T07:19:35.263+00:00