SQL AGENT History

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  February 11, 2009 at 8:22 am

  #127665

  Hi...In one of our production servers, we are able to view only last job execution history in the job's history log.....But in all the other servers we find multiple histories like 15 days history..... How can we change this to display all the previous logs in the Job's History?? Please let me know this....Thank you

• CrazyMan

  SSChampion

  Points: 12560

  More actions

  February 11, 2009 at 9:01 am

  #942240

  Check the agent properties, and look for Agent History, this properties needs some change 🙂

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  February 11, 2009 at 9:04 am

  #942245

  Thank you for the reply....I figured it out that It is maximum History log size limit...I posted if we have any other settings....