July 19, 2002 at 8:25 am
I have problem where there the agent keeps stopping, but it still shows as running when you look at services in control panel. this is causing jobs to fail regularly I have looked everywhere I can think to find more info eg event viewer to no avail.
we are running sql2000 sp2 on a w2k sp2
any help appreciated
July 19, 2002 at 10:08 am
Does the sql agent log file give any more details? (Right click on the sql agent and choose 'display error log')
Steven
July 19, 2002 at 10:34 am
there are several error messages about email user that could not be notified when the job completed could this stop the service
July 22, 2002 at 1:37 pm
Did you get a stack dump that shows an execution of xp_sendmail in it? If so, you have hit a bug in SQL Server 2000 service pack 2 SQLMAP70.dll. Replace it with the version from service pack 1 and you will be fine.
July 22, 2002 at 3:29 pm
If you would, post the stack dump, as mentioned by rwims. It may be helpful to others as well who run across the same issue.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy