SQL Server agent - Job History

  • Hello,

    we have a maintenance jobs running once a week.  This job contain several steps. When I display the "Show history" window for this job,  I only see the last execution.  
    When I do the same with a smaller job I can see more than one execution.  How can I see more than on execution for my big job?

    thanks

    MArtin

  • How regularly does your other job run? I suspect that actually what has happened is that the log for your previous (runs) have been deleted due to one of the history settings on your SQL Agent. If you right click SQL Server Agent in the Object explorer, select Properties, and then navigate to the History Pane, what are the values for the settings there?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Yes the other job I have checked runs daily while the biggest job runs once a week

    Limit size of jib history is checked
    Maximum job history log size (in rows) :  2000
    Maximum job history rows per job : 200

  • mdube 62615 - Monday, February 4, 2019 8:40 AM

    Yes the other job I have checked runs daily while the biggest job runs once a week

    Limit size of jib history is checked
    Maximum job history log size (in rows) :  2000
    Maximum job history rows per job : 200

    Then I suspect you've had more than 2000 total rows in your history and the rows from a week ago have been deleted. I don't know what would be a "good" value for Maximum job history log size (in rows) (as I don't know how many jobs you have you your server), but if being able to view a history of weekly jobs is important you'll need to increase that value.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply