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 |
|
CraigMuckleston
Starting Member
6 Posts |
 Posted - 2008-03-07 : 07:48:06
|
| I have been setting up DatabaseMail on my SQL2005 server. I have configured it correctly and sent a test email successfully (by right clicking Database Mail and selecting Send Test Email)I have configured my operators with the correct details, but don't get any emails after the job has run. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-07 : 09:10:42
|
| Did you enable Database mail in SQL Server agent Properties.ALso Enable Database mail on SQL Server surface area config.Configure Outlook as well. |
 |
|
|
CraigMuckleston
Starting Member
6 Posts |
Posted - 2008-03-07 : 09:47:04
|
| I have checked that SQL Server Agent has been enabledSQL Server Surface Area has also been enabledI am using an external SMTP server to send my mail. The SMTP must be configured correctly because I can send a test email.Do I need to restart any of the servcies? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-07 : 11:34:35
|
| Yes, SQL Server agent service. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-07 : 22:33:46
|
| How did you set job notification? |
|
|
|
|
|
|
DatabaseMail Issues