Sysjobhistory table is not updated in msdb sql 2000

• kaushikrsharma

  SSC Enthusiast

  Points: 142

  More actions

  November 13, 2009 at 8:35 am

  #216705

  I have SQl 2000 with SP4. SYSjobhistory table in msdb database is not updated . my all jobs are running and i have enough space for SQlserver agent log . and max no of log is also good number .

  can you give me solution?

  Thanks

  Kaushik

• kaushikrsharma

  SSC Enthusiast

  Points: 142

  More actions

  November 13, 2009 at 10:01 am

  #1079068

  come on guys somebody told me yuo will get reply very soon

• kaushikrsharma

  SSC Enthusiast

  Points: 142

  More actions

  November 13, 2009 at 1:51 pm

  #1079262

  i got the problem. but looking for solution.

  this is due to end of job it is not calling stored procedure callled Sp_sqlagent_log_jobhistory

  this stored procedure automatically called and write result of the job into sysjobhistory table in msdb.

  i saw in profiler it doesnot calling store procedure . now what sholud i do so that agent call automatically call this sp

  thanks

  Kaushik sharma