Hi
I'm trying to use the run_status in the sysjobhistory table to find out whether there are jobs currently running, but it seems that there is never a job step written to sysjobhistory while it is actually in progress, i.e. run_status = 4. For example if I have a job with 6 steps, and its currently running step 4, I will see records in sysjobhistory for steps 1 to 3, showing a run_status of 1, but step 4 won't be written until its completed. There are never any records in the table with a run_status of 4, even when I have several jobs currently executing.
Does anyone know whats happening here or am I missing something?
Many thanks in advance
Clare
I'm trying to use the run_status in the sysjobhistory table to find out whether there are jobs currently running, but it seems that there is never a job step written to sysjobhistory while it is actually in progress, i.e. run_status = 4. For example if I have a job with 6 steps, and its currently running step 4, I will see records in sysjobhistory for steps 1 to 3, showing a run_status of 1, but step 4 won't be written until its completed. There are never any records in the table with a run_status of 4, even when I have several jobs currently executing.
Does anyone know whats happening here or am I missing something?
Many thanks in advance
Clare