January 21, 2010 at 12:09 am
Hi
In my sql 2005 server dbmail is not working.I created mailprofile,account.
when i used the command
EXEC msdb.dbo.sp_send_dbmail @recipients= @EMail_ID ,
@subject = 'New Job Post' ,
@body = @Job_Description_brief ,
@body_format = 'HTML' ,
@profile_name = 'Profile Name';
status is showing mail queued.
From other sql servers it is working fine.I dropped and recreated profile but still same issue .Mail is not going.
Kindly help
January 21, 2010 at 12:36 am
First of all check if the Database Mail is enabled in surface area configuration.
Second, check SMTP Server is configured correctly and prot 25 is open as default it's communicating to this port.
http://technet.microsoft.com/en-us/library/ms190658.aspx
Also check description column of following log table for further trouble shooting.
SELECT * FROM msdb.dbo.sysmail_event_log;
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 21, 2010 at 8:06 am
If you have Anti-Virus running make sure that Database Mail is added as an exception.
Here are a couple of blog posts about database mail:
http://wiseman-wiseguy.blogspot.com/2009/07/mystery-of-failing-database-mail.html
http://wiseman-wiseguy.blogspot.com/2009/09/what-happened-to-that-email.html
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
January 21, 2010 at 8:19 am
restart sql server agent
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply