maintenance job frozen in executing state

Question

I have several maintenance job stuck on my sql server , stuck from the 10th of may , what should I do first? I try to stop them from sql agent but nothing happens

I did a check with sp_whoisactive

have this kind of statments (327853387ms)PREEMPTIVE_OS_AUTHZINITIALIZECON

update: I restarted the agent but the jobs after a while re appear with the ne execution (they are scheduled jobs)

do I have to reboot the whole sql server 2017? – Gabriele D'Onufrio May 13 '20 at 20:35 — Gabriele D'Onufrio, May 13 '20 at 20:35

score 1 · Accepted Answer · answered May 15 '20 at 07:28

1

At the end the solution was to restart sql service, the restart of the sql agent was not sufficient

answered May 15 '20 at 07:28

Gabriele D'Onufrio

405
1
5
17

maintenance job frozen in executing state

1 Answers1