August 8, 2011 at 7:38 am
we have installed SQL Server 2005 (standard edition) with SP3 on a SQL cluster.
after the installation when we configured database mail. when i tried to send test mail the only message i saw was mail queued but didnt received the mail.
the error i am seeing in log is:
The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following 'Error executing extended stored procedure: Invalid Parameter.
any idea?
August 8, 2011 at 8:40 am
You can dig into the dbmail system tables in the msdb database to get a better idea what happened. Look at sysmail.allitems and sysmail.faileditems to see the status of your message (sent vs. Retrying/failed).
Read in BOL for more details; great troubleshooting section: http://msdn.microsoft.com/en-us/library/ms188663.aspx
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply