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 |
|
jstormoen
Starting Member
30 Posts |
 Posted - 2006-07-24 : 10:47:22
|
| we have encountered problems from one of our vendor applications where an xp_sendmail command will fail locking up all of the subsequent tries to email from other jobs. I have found no way to fix this besides restarting MSSQL Service. 2 questions 1) is there another way to correct this when it happens ? 2) I need to find out how and why it is happening - any ideas of ways to find this ? below is the snippet of code where I believe it failed last - could it have to do with the @query ? EXEC master..xp_sendmail @recipients = @TO, @query = 'select ... ActivityDate ', @subject = @s, @message = @msg, @attach_results = 'TRUE', @width = 350 |
|
|
|
|
|
SQL Mail problems