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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2013-10-14 : 07:59:51
|
| this has happened a few times that we notice that we are not getting mail from the sql if i restart sql and then run exec sysmail_stop_spexec sysmail_start_spit starts again but it takes till someone alerts me it's downis there any way around this or at least to get an alert? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-10-14 : 12:02:51
|
| Check the Database Mail logs (system tables in msdb that start with sysmail).Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
sql mail stops