Job duration when a crash occurs

Nath · August 7, 2020 3:57PM

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 · August 10, 2020 11:59AM

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 · August 10, 2020 12:45PM

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

Russell D · August 11, 2020 8:11AM

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 · August 13, 2020 8:15AM

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

susan · August 30, 2020 3:15AM

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.

Job duration when a crash occurs

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk