Hung SQLAgent Jobs
-
Intermittently, my SQL Agent jobs will stop running. The jobs will hang showing a status of "Executing Job Step '1(Step 1)'". I have to stop/start the SQLServer service to get them running again. I know for sure this happens after the weekly optimizations job runs, plus it has happened a couple of times mid-day.
The job is successful, but because it is hung executing it doesn't run again. The last line of my database maintenance plan text file log will show "Emailing report to operator 'DB Admin Group'".
SQLMail is a factor. xp_sendmail run from Query Analyzer also hangs. If a database maintenance plan does not 'Email report to operator' the job will not hang.
SQLAgent Mail works. Sending email from Outlook on the console of the database server works as well.
I am running MS SQL 2000 Enterprise Edition (8.00.818) on a active/passive clustered Windows 2000 Advanced Server. I also have log shipping setup going to a standby server.
Thanks in advance, John
-
You know SQLmail and clustering is not supported
.That's why I use smtp-mail on my clustered sqlservers.
SQLmail works, but only for a while, then it gets stuck and the _server_ needs a reboot to get it back to work(for a while).
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I have heard that if you exchange server is rebooted you need to stop and start the mail services on the SQL server. You can include this at the top of your job and see if it helps:
xp_stopmail
xp_startmail
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply