timscronin
SSCertifiable
Points: 6851
More actions
March 3, 2003 at 3:38 pm
#105447
have run into problem where a sqlgent job(usually log shipping gets stuck). Can't stop and start agent so sql server reboot is all that fixes it.
March 6, 2003 at 8:00 am
This was removed by the editor as SPAM
Steve Jones - SSC Editor
SSC Guru
Points: 736445
March 6, 2003 at 9:59 am
#450425
Does the stop screen in services just hang? Does it report an error? Have you checked the SQLAgent log and the Event Log? It might be rolling back. Check sp_who2 when you try this and see if anything is in rollback status.
Steve Jones
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones
http://www.dkranch.net
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply