Problem in executing msdb.dbo.sp_send_dbmail

Question

Problem in executing msdb.dbo.sp_send_dbmail

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

DBA in Unit 7 SSCarpal Tunnel Points: 4059 More actions · Answer 1

rahul170 (2/18/2009)
There is no problem related to parameter as the same code is running fine in our local server and at another client's server

Maybe I misread, I thought you were running the same code on different servers.

So, you did check the parameters for the SP_SEND_DBMAIL on the Server that you have problem with and looks fine?

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

Ramesh (2/18/2009)
Jack Corbett (2/18/2009)
Actually this was changed in SP1, see this blog post - http://wiseman-wiseguy.blogspot.com/2008/03/64-bit-database-mail-sql-server-agent.html
...I was actually correcting my statement in a new reply but you beat me on it:D.
Now for the OP, can you cross check the parameters for the procedure sysmail_delete_profile_sp? It should have an additional parameter @force_delete which added in SP2 release. And if you don't find have such parameter, then there are chances that the SP2 has not correctly applied. Check Logs to see if there's something failed during install.

Here is a thread on the msdn forums that verifies that this is likely the issue, http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/35c4c8b8-c18f-44a5-b8f5-7e656d6e74c9/

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

rahul170 SSC Veteran Points: 261 More actions · Answer 3

Below are the servers information where job is running and where it is getting failed:

Query output on server where job is running fine

Query - select @@version

Query Output -

Query - SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Query output

9.00.3042.00SP2Standard Edition

Query output on server where job is giving error: