One of our ETL servers had to be restarted and a job was in the middle of execution. It was on the 2nd of 6 steps and now the job agent shows that it has been running for 15 hours back on step 1.
Currently running SQL Server 2012 (11.0.3).
Most of the fields in the Log File Viewer are blank, except for duration, job name and this message:
We haven't stopped the job yet.
- Can anyone explain why this is happening?
- Is the best practice before any server restart to stop/disable all jobs?
sp_whoisactive showed the job running but there wasn't any CPU load or anything like that. Unfortunately, I am not able to share the code, most I can divulge is it's a 6 step process running a SQL server package.