msdb.dbo.sysjobhistory and msdb.dbo.sysjobactivity issue

• ralu_k_17

  SSCrazy

  Points: 2190

  More actions

  October 8, 2015 at 3:38 am

  #308610

  Hello,

  I am having a weird behavior with the system tables: msdb.dbo.sysjobhistory and msdb.dbo.sysjobactivity.

  Without anyone touching the configuration of the SQL server, a few weeks ago, the table msdb.dbo.sysjobhistory stopped showing the real history of the SQL Jobs. It seems like the lines in the system table are not updated according to the actual execution of the jobs.

  And this morning in msdb.dbo.sysjobactivity, a bunch of lines for different jobs got updated to stop_execution_date = NULL, even though the jobs did not start their execution, and I also have jobs with the starting date from July and stop_execution_date = NULL, which are not actually running.

  Everyone having access to the server, say they did not touch any configuration.

  Is there someone around who had experienced this behavior?

  And also, is there a way to find out if there were some modifications made to how the information is inserted or updated on this sys tables?

  Thank you so much for any help!

• samber

  Newbie

  Points: 3

  More actions

  May 4, 2016 at 5:53 am

  #1876542

  Hi,

  Did you found an answer to your question ?

  --

  Sam