Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
job history question?

Answered job history question?

  • Friday, January 04, 2013 4:55 PM
     
     
    Sign In to Vote
    0

    Hello,

    We have multiple jobs running on one of the server, each job is running based on SSIS package.

    Question is "each job has different history dates, when I see the history from the UI, why so?" [e.g. Job1 has history of last 3 days but Job2 has history of last 4 days]

    Can anybody help me, why this difference? how can I set this history so that they all has same days of history?

    Thanks

    Regards,

    Kumar

    Please do let us know your feedback. Thank You - KG, MCTS

     

All Replies

  • Friday, January 04, 2013 4:59 PM
     
     Answered
    Sign In to Vote
    0

    What you are seeing is most likely a function of the Maximum Job History Rows per job setting in the SQL Agent.  I'm guessing that your Job1 enters more history lines than Job 2.

    Chuck Pedretti | Magenic – North Region | magenic.com