Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-09 : 09:10:23
|
| Ray writes "I've recently experienced unpredictable behavior with my SQLMail notifications. Scheduled jobs are supposed to email me upon completion, but will report "Performing completion actions..." and all mail services on my SQL Server lock up (I am unable to send mail through scheduled jobs or xp_sendmail). I never recieve the mail notifications and the jobs never complete.I've researched this on Microsoft's TechNet. I found that if SQL Server loses a connection to its Exchange Server, a dialog box will pop up. Since SQL Server is running as a service, the dialog box will never actually be visible and never returns control back to SQL Server.The only suggestion provided was to run SQL Server as a console program and see if this is the case - there was no solution, workaround or fix.Has anyone else experienced this?(The SQLMail problem, that is.)I am running SQL Server 2000 with Service Pack 2 on an Advanced Server." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-09 : 16:13:37
|
| That is because there is no workaround or fix, besides using Exchange.If you don't use Exchange, you must gaurantee 100% connectivity. Otherwise sqlmail will lock up.It is really more of a connectivity or Network problem than a sqlmail problem. There is no way to get a service to respond to a dialog box.-Chad |
 |
|
|
dontipton
Starting Member
8 Posts |
|
|
|
|
|
SQLMail lockup