This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 90%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
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!
There are some settings for log size / retention / count, see
https://learn.microsoft.com/en-us/sql/ssms/agent/resize-the-job-history-log?view=sql-server-ver16
Unfortunately, this isn't it. The maximum number is filled and it works for other jobs (I can see many days worth of log file for others), but not for that particular one job automation log file which only has one day's information.