RE: Job in hung state..How to fix

SSChampion

Points: 10332

July 17, 2017 at 4:46 am

#1951108

John Mitchell-245523 - Monday, July 17, 2017 4:00 AM
You've been around long enough to know that you haven't provided nearly enough information. What does the job do? What makes you think it's hung? How long does it normally take and how long has it taken so far this time? Does the same thing happen if you run the same command(s) outside of the job?
John

Hi John,
The job does DBCC CHECKDB on a single database.It runs every saturday. It usually takes 21 hours to complete, but for the last 2 saturdays, it took 1 day 7 hours 32 minutes to complete. How to find out why it took longer time?