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.
On
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".
With the minimum provided information you posted i think that you should check what job steps do on finish.