Increasing job history rows for a job

• Atif

  Hall of Fame

  Points: 3578

  More actions

  September 3, 2008 at 2:37 am

  #126154

  Using the following query

  select * from msdb..sysjobhistory

  I get maximum 100 rows as history for any job. These are last 100 records. is it possible to configure my server for storing more than 100 records in this table for a job?

  DBDigger Microsoft Data Platform Consultancy.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 3, 2008 at 2:38 am

  #866383

  Sure. In SSMS go to SQL Server Agent -> Right Click -> Select Properties -> Select History and you can set the number of history rows total and per job.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question