Problem with hung up Maintenance job

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736568 More actions · Answer 1

I'd kill the spid. Try a couple kill <x>. Does this bring back a rolling back message?

Steve Jones

Tom Goltl SSCertifiable Points: 5815 More actions · Answer 2

You might try shutting down the sql agent. I thnik that is the service that the maintenance plans run under.

Just a thought.

Tom

Steve Jones - SSC Editor SSC Guru Points: 736568 More actions · Answer 3

Good idea. Let us know if that works.

Steve Jones

mbinder SSC Veteran Points: 269 More actions · Answer 4

Thanks for the quick responses but I have tried both of these suggestions with no luck.

There is a rollback message of 0 seconds and the SQL agent is 'stuck', we can neither truly stop nor restart.

Steve Jones - SSC Editor SSC Guru Points: 736568 More actions · Answer 5

I hate to say it, but you probablty need a reboot. Disable the job and then check the logs. We'll keep thinking.

Steve Jones

mbinder SSC Veteran Points: 269 More actions · Answer 6

Thanks for trying. We are rebooting...

I'll let you know if we find out anything further...