SQL Server job history log

Question

We have several SQL Servers on which same job is running every hour. One one server it shows job history of even previous day; however on other; it doesn't show of previous day. How do I have to configure this. Thanks in advance.

Answer 1

Hi @DM ，

Please check your properties of the SQL Server Agent, it has a "History" page where can be configured to limit the size of the job history log

Or you need to check if you have a maintenance plan or any other that includes a task to delete history tables to only one day

To get the history of the job, you can try to query sysjobhistory table and SQL Agent Job Activity Monitor

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.