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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 database mail

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_sp
go
exec msdb.dbo.sysmail_start_sp
go
Go to Top of Page

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2010-06-25 : 06:53:55
thanks that did it :)
Go to Top of Page

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.

Go to Top of Page

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?
Go to Top of Page
   

- Advertisement -