March 5, 2013 at 5:53 am
Hi,
My Database Mail works fine, but every time i open SSMS, in order to send mail. I have to execute sysmail_start_sp to shoot the mail.
What should i do so that it will never stops, as i am suppose to put this Email in a JOB.
March 5, 2013 at 10:29 pm
no one knows the answer to this..!!?
March 6, 2013 at 12:50 am
I recommend that you use Database Mail Configuration Wizard, the Database Mail Configuration Wizard provides a convenient way to manage Database Mail configuration objects and enables Database Mail.
For more information, please see:
Database Mail Configuration Wizard
http://msdn.microsoft.com/en-us/library/ms175951.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 6, 2013 at 12:59 am
Another thing,
send a test mail to investigate the point of failure.
Right click database mail –View database mail log to see error or we can SELECT * FROM msdb.dbo.sysmail_event_log ;
Check the sent_Status column in the sysmail_allitems table. The four values are sent, unsent, retrying and failed.
If the status is sent and the recipients hasn’t received the email yet, that the Database Mail external program successfully delivered the e-mail message to the SMTP server but it failed to deliver the message to the final recipient. At this point, the SMTP needs to be troubleshooted (perhaps engaged your Exchange or Mail server team)
If the status is unsent or retrying, it means that the Database Mail has not yet processed the e-mail message or is in the process of retrying after a failed attempt. This could be due to network conditions, volume of messages, SMTP server issues, etc. If the problem persists, use another profile or another mail host database.
If the status is failed, it means that the Database Mail was unable to deliver the message to the SMTP server. Check the sysmail_log table and the destination address. Also be sure that there are no Network or SMTP issues.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 6, 2013 at 1:13 am
I have created the Email profile using Wizard only, i am able to send mails also, Just that sometimes it fails saying that sysmail_start_sp needs to execute. why is that , cant i start a service or something. So that i should not run the same everytime.:sick:
March 6, 2013 at 2:18 am
Bhuvnesh (3/6/2013)
SELECT * FROM msdb.dbo.sysmail_event_log ;
Have you used this ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply