May 19, 2003 at 7:56 am
I have set this up on Windoes 2000 through outlook and works fine. Set up in sql 2000 works ok with SQLagent when you set up a user and select test or get an alert. But when i use "exec xp_Sendmail @Recipients ='recipent' , @Message = 'message'" to send an email it sends the message but after that it will not send any more mail and outlook will not open until the server is rebooted.
Can anyone tell me why or give me tips on how to debug this problem.
Many thanks
May 20, 2003 at 10:05 am
I have been looking into this problem and have come to a conclusion that SQLMail is different from SQLAgentMail in the way it implements the mapi. i have setup alerts and they have worked without failure, but using sql mail with xp_send seems to send and then sql mail appears to hang,while agentmail still works telling me a MAPI session can still be created. i did a trace on SQL Agent and it seems to use XP_SqlMAgentNotify(xpstar.dll) to send MAil, where as xp_sendmail uses sqlmap70.dll. Does anyone know the differnces in the way these dll work in terms of sending mail, maybe that is why one seems to wotk with iNotes MAPI and the other doesent? Or if their are no differnces is their something in sqlmail that i have to set to stop it hanging after the first send(Startmail)?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply