Database Mail + sysmail_start

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Database Mail + sysmail_start_sp

Database Mail + sysmail_start_sp

Rate Topic

Display Mode

Topic Options

Author

Message

parth83.rawal

Posted Tuesday, March 05, 2013 5:53 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, March 06, 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

parth83.rawal

Posted Tuesday, March 05, 2013 10:29 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, March 06, 2013 11:48 PM
Points: 66, Visits: 160

no one knows the answer to this..!!?

Post #1427168

Bhuvnesh

Posted Wednesday, March 06, 2013 12:50 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1427216

Bhuvnesh

Posted Wednesday, March 06, 2013 12:59 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1427217

parth83.rawal

Posted Wednesday, March 06, 2013 1:13 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, March 06, 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. Sick

Post #1427224

Bhuvnesh

Posted Wednesday, March 06, 2013 2:18 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, June 13, 2013 7:03 AM
Points: 2,562, Visits: 3,453

Bhuvnesh (3/6/2013)

SELECT * FROM msdb.dbo.sysmail_event_log ;

Have you used this ?

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1427244

« Prev Topic | Next Topic »

Permissions