How can we help you today? How can we help you today?

Job duration when a crash occurs

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.



Nath
0

Comments

5 comments

Sort by
  • 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.
    Russell D
    0
  • Nath
    Russell, I'm running the version 10.0.8.27810 of Monitor.
    Nath
    0
  • 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).
    Russell D
    0
  • Nath
    Thanks for your help, Russell. I upgraded yesterday, and today the alert 'Job duration unusual' hasn't raised. 
    Nath
    0
  • 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.
    susan
    0

Add comment

Please sign in to leave a comment.