2

I have multiple SQL Server Agent jobs that hang indefinitely upon first run after the server bounces. The jobs execute as scheduled, but never perform any action and stay in "Executing" status indefinitely. Rebooting the Agent from the SQL Server Configuration GUI resolves the issue.

NOTES:

  • Neither the Engine logs nor the Agent logs seem to show anything of value.
  • I have tried setting the Agent Service to "delayed start" in Windows Services.
  • The Agent is currently using an MSA.
4
  • All jobs or just some? What step types do the frozen jobs use? Can you see any open connections from the job step, and what are they doing if so? – LowlyDBA - John M May 11 '20 at 17:47
  • I had been thinking it was all jobs, but now it looks like it may only be the jobs that have "Operating System (CmdExec)" type steps. – ca_elrod May 11 '20 at 18:13
  • What is your exact version of SQL? Do you have the service packs and cumulative updates? – Danielle Paquette-Harvey May 11 '20 at 18:26
  • SQL Server 2016 13.0.5026.0 – ca_elrod May 11 '20 at 19:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.