0

I have a problem: I can't find a record with run status = 4 in msdb.dbo.sysjobhistory while a job is in progress.

It appears just for some special job. If we have a running job, it does not show in SSMS (job->view history) and in msdb table and just when job finished, it records in msdb table with run status 1 or 0.

I want to know what the reason for this issue is, and why this happens just for some jobs, but not all jobs?

1 Answers1

-1

This is a pretty common question. Does this post over on Stack Overflow cover what you're looking for?

Brendan McCaffrey
  • 3,444
  • 2
  • 8
  • 29