Sample Header Ad - 728x90

Find jobs stopped prior to completion by Shutdown Sequence

3 votes
1 answer
82 views
I am looking to report on jobs that were running when the instance is rebooted so that I can investigate and requeue. I have tested this scenario and sometimes I can identify them in msdb.dbo.sysjobhistory via: > The job was stopped prior to completion by Shutdown Sequence 0 Sometimes msdb.dbo.sysjobhistory has no data however it will be the last_outcome_message in msdb.dbo.sysjobservers. Other times, I've rebooted an instance with a running job however neither location has this information. I understand that services should be stopped prior to shutdown however that is outside of my control. Is there a more reliable method to identify such jobs? Thanks
Asked by beehive (179 rep)
Jun 25, 2025, 12:15 PM
Last activity: Jun 26, 2025, 04:11 AM