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 |
|
AlanDNelson
Starting Member
7 Posts |
 Posted - 2008-02-28 : 16:46:41
|
| I am looking for a way to disable DatabaseMail90.exe (temporarily) while still allowing emails to queue up.At first, I thought the solution was sysmail_stop_sp... but if I use this... calls to sp_send_DBMail fail with the following message:Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.I'd like the emails to be queued... I just want to postpone sending them. Anyone know how to do this? - Alan D. Nelson |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 22:12:25
|
| Rename the file? |
 |
|
|
AlanDNelson
Starting Member
7 Posts |
Posted - 2008-03-03 : 16:23:26
|
| I SUPPOSE I could do it that way. I was hoping to find a method that would work without generating a "file not found" error. I was hoping something like a service I could shut off, or a queue I could disable, or a sp_procedure I could run... or something like that. |
|
|
|
|
|
|
Disable DatabaseMail90.exe