Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Mail + sysmail_start_sp Expand / Collapse
Author
Message
Posted Tuesday, March 5, 2013 5:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 11:48 PM
Points: 66, Visits: 160
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.
Post #1426773
Posted Tuesday, March 5, 2013 10:29 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 11:48 PM
Points: 66, Visits: 160
no one knows the answer to this..!!?
Post #1427168
Posted Wednesday, March 6, 2013 12:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:01 AM
Points: 2,840, Visits: 3,968
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
Post #1427216
Posted Wednesday, March 6, 2013 12:59 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:01 AM
Points: 2,840, Visits: 3,968
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
Post #1427217
Posted Wednesday, March 6, 2013 1:13 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 11:48 PM
Points: 66, Visits: 160
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.
Post #1427224
Posted Wednesday, March 6, 2013 2:18 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:01 AM
Points: 2,840, Visits: 3,968
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
Post #1427244
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse