Job history

• sarita Garg

  SSC Eights!

  Points: 824

  More actions

  March 7, 2005 at 4:30 pm

  #109278

  I have a sql 2000 server where I am scheduling back up jobs.  I can execute the job but it is not logging any job history in the msdb database sysjobhistory table.  Will greatly appreciate if someone can help.

  Thank you

• Helen-84411

  Hall of Fame

  Points: 3320

  More actions

  March 7, 2005 at 8:32 pm

  #545807

  Hi,

  You have to increase the job history log.  Please see below

  How to resize the job history log (Enterprise Manager). This is due to insufficient log space(i assume). See the lines from BOL

  To resize the job history log

  1. Expand a server group, and then expand a server.

  2. Expand Management, right-click SQL Server Agent, and then click Properties.

  3. Click the Job System tab, and then select Limit size of job history log check box.

  4. In the Maximum job history log size (rows) box, enter the maximum number of rows the job history log should allow.

  5. In the Maximum job history rows per job box, enter the maximum number of job history rows to allow for a job.

  Good Luck

  

  Good Hunting!

  
  Helen
  --------------------------------
  Are you a born again. He is Jehova Jirah unto me