Post reply

SQl Agent Job History Issue

  • April 3, 2012 at 9:52 am

    #391931

    Hi Guys..

    when i am looking in history of particular Job it shows me from 03/26/2012 to 04/02/2012 and i want to see the history before 03/26/2012 . anyone has idea how i can see that?

    Thanks

  • April 3, 2012 at 9:57 am

    #1468321

    do you have a "Clean Up History" task that runs in a Maintenance Plan?

  • April 3, 2012 at 10:00 am

    #1468324

    no its not a part of Maintenance plan ..

  • April 3, 2012 at 10:03 am

    #1468325

    then check the Agent properties.

    the defaults for history are 1000 rows or 100 per job.

  • April 3, 2012 at 10:08 am

    #1468328

    its changed from default to 15000 rows...

  • April 3, 2012 at 10:13 am

    #1468329

    well, whatever it is, apparently it is not enough.

    to the original question though, you cannot see history that is not there.

    the SQL Agent job history either gets wiped out with a Maintenance Plan that uses the Clean Up History task or from the SQL Agent properites page under History.

    If you want to look at job history for a longer period of time, un check the Limit size of job history log and then check Remove agent history box. choose a time frame you feel is long enough.

Viewing 6 posts - 1 through 5 (of 5 total)

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