That's great idea, liteswitch and JeremyE. I've just setup a simple job to do a SELECT '1', put a notification onto it and it will fire in 10 minutes. Will...

Hi JeremyE,

I checked today, but still didn't get any email notification that the job succeeded, which I should be getting. I've enabled the profile, as you suggested, and restarted the...

I was not aware of the fact that I'd have to restart SQL Agent, before it would see the changes that I made to the Database Mail profile. I've just...

Ummm, no. (As I hang...

Hello Tim,

In the last couple of days I've finally gotten a chance to...

Grant Fritchey (10/22/2013)

---

tabinsc (10/22/2013)

---

Thank you Steve for this article. This is something I need to do but haven't done yet. I guess writing the first one is the...

I, too, can find things easier here....

Oh, OK, then I'd better get a hold of my sys admin and...

We went to Office 365 months ago, and it worked fine then. The only thing that's different now is having migrated to SQL 2012.

I believe the answer to your question is yes. We have Office...

As far as I can determine, the profile has been set correctly....

Thank you, that was very useful. I've run the SELECT statement that you gave me in msdb and here's the results:

The mail could not be sent to the recipients because...

John Jakob (10/14/2013)

---

Like the other poster said, what happens when you try sending a test email?

If you try something like this:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'DBMailPublicProfile', ...

Thanks!

Thank you, this does help, but I wonder about setting up an on-premise SMTP server? We didn't have to do that before, when we had...