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 - 2010-06-25 : 04:26:33
|
| i'm using database mail to send emails.it's been working fine for months and now today it's suddenly not sending the emails. i'm getting Mail queued.but never get the emails.what could be causing this? |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2010-06-25 : 06:22:48
|
| Run the following. Hope it fixed the issue.exec msdb.dbo.sysmail_stop_spgoexec msdb.dbo.sysmail_start_spgo |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2010-06-25 : 06:53:55
|
| thanks that did it :) |
|
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2010-06-25 : 07:08:10
|
| Nice to know that problem is solved.In our environment we have an SQL Agent job which run periodically and runs the above script if there is any mail found in the queue. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2010-08-25 : 12:45:30
|
| i'm having this same problem again but this time it's not working any other ideas what could fix this? |
|
|
|
|
|
|
database mail