I've got a few minutes to look into this, so I took the time. This time I ran another job which I know is supposed to send out an email...

OK, I found the problem, and it wasn't with the database. Actually, running SQL Profiler, indirectly, pointed to what was wrong. As I said previously I couldn't find an INSERT...

Hello Kevin,

I've finally had a chance to give your suggestion a try. I got SQL Profiler running, but here's what it gave me:

exec sp_executesql N'UPDATE [ASISubstanceUse] SET [ClientNumber] = @ClientNumber,

[CaseNumber]...

We had to move SSRS to a different server.

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....