Hi -

I have an instance of SQL 2k5 on x64. In the past (SQL 2k), others had set
up notifications of job completion for various SQL Server jobs in Enterprise
Manager. I tried to configure the same thing, and opened up and configured
database mail and SQL mail. Well, I get this error on the job now:

SQL Mail does not work with the 64-bit version of SQL Server [SQLSTATE
42000] (Error 17938). The step failed.

I acknowledge the SMTP/MAPI distinctions. Is there a way to configure this
SQL instance to use db mail instead of SQL Mail to send these automatic
notifications, which are specified through the Enterprise Manager
(Jobs-properties-notifications-email)? I suppose if EM uses the email stored
procs, I could just map one proc to be called from another. Any easier ways ?

Thanks for any insight.

Steve

Thanks, but I checked all of that, and it is as you say. I even re-started
the SQL Server Agent. But the same error re-currs .. it's as if it's not
using db mail for the "notification" (is that distinct from an "alert") ..

Steve

"Ekrem Önsoy" wrote:

Just to finish - I found out what would clear it. It's cycling the Agent. I
did it, but there was apparently an uneven email delay.

"Steve M" wrote: