-2

I have 13 Sql jobs that run at night starting at 11:30pm. Most of them never finish. When I restart the sql agent job it and run the jobs manually it will run but when they run on their own they will continue to run until I stop them. I have a couple that ran for a full 24hours. Does anyone know how I can fix this ?

I have restarted the sql agent, I have checked the blocked, I have run all the SSIS packages in Visual Studio and they are running.

Andrea
  • 1

2 Answers2

0

With the minimum provided information you posted i think that you should check what job steps do on finish.

Kostas Nitaf
  • 428
  • 1
  • 2
  • 12
0

I had faced this issue in the past, there was one intermediate step, say e.g. Step 3, for that step "On Success" event was set to "Go to Step 1", this resulted in an Infinite loop. So make sure to check for each step "On Success" and "On Failure" events, and also make sure that last step is set to "Quit the job reporting success".

Asif Khan
  • 29
  • 5
  • I have tried this and these are all set to quit the job reporting success. – Andrea Jun 22 '23 at 15:30
  • Are the job getting stuck on any particular Step? What do you see when you go to job history? – Asif Khan Jun 22 '23 at 21:02
  • That's the weird part. I was able to get some of them to succeed if i manually ran them on their own and others will fail at different steps than others. Less than a month ago this was working just fine but all of a sudden they stopped working. That's what's so confusing to me. Each day I'm having to restart either the server or the job agents themselves. – Andrea Jun 26 '23 at 10:53