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
Last activity: Jun 26, 2025, 04:11 AM