Job duration when a crash occurs

Nath

Hi, my SQL Server VM crashed on the 28th of July during the execution of the job making the full backup of a database (3.5TB). This job is executed everyday. Since that day, I receive everyday an alert 'Job duration unusual', with Job started at : 28 Jul 2020 and Job Ended : Unknown. Duration of the job is 10 days. It seems SQL Monitor believes this job is still running since the 28th of July.
Is there a way to resolve this issue? 
Thanks.

Russell D

Hi Nath, can you confirm the version of Monitor you're running please? This looks like an old bug we fixed a while ago.

Nath

Russell, I'm running the version 10.0.8.27810 of Monitor.

Russell D

Yes that makes sense then. This looks like its SRP-12937, which was fixed in 10.0.9. Are you able to upgrade? I can provide a link to that exact version if you specifically want it, otherwise you should be able to get the latest release here https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_10.2.3.31956.exe (this requires server 2012 R2 or higher though).

Nath

Thanks for your help, Russell. I upgraded yesterday, and today the alert 'Job duration unusual' hasn't raised. 

susan

when your mobile facing a crush  that needs to be rectify. mobile engineer can resolve this issue .  mobile repair dubai  can solve this matter  so easily.  before do the rectification work they will do investigation the issue  with expertise.