Company: Link Technologies
Case No: L12459
Logged By: Sanjay (Link Technologies) on 06 Feb 2013 09:39PM
Priority: Not Applicable
Product: Other
Group: To be assigned
Time Taken: 0.00
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay
Resolve By: Wednesday, 06 February 2013 09:39 PM [4069 days since logged date]
Status: Closed
Subject: Configuring SQL Server to send Emails using database Mail
Summary:    

Link Technologies Software systems use database mail to send out alerts. The steps below can be used to setup database mail and enable configuration options for alerts to be sent our successfully:

-- Set configuration options for SQL server to send emails.
sp_CONFIGURE 'show advanced', 1
GO
RECONFIGURE
GO
sp_CONFIGURE 'Database Mail XPs', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ole Automation Procedures',1
GO
RECONFIGURE
GO

-- Now create a Database Mail Profile named EMAIL

--Then use this to test your email profile.
EXEC msdb.dbo.sp_send_dbmail @profile_name='EMAIL',
@recipients='sanjay@LinkTechnologies.com.au',
@subject='Test message from DB Mail Profile named EMAIL',
@body='This is the body of the message.'

You can check these tables to determine email status

LBS_Notifications - This table holds the email details including email to, email body, email status etc

LBS_mail_failures - Shows any mail failures with error details

LBS_Config - has configuration options that DB Mail uses to send alerts

Audit Notes:
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12459 in the subject line of all emails regarding this issue.

Document size: 1.7 KB
For call complaints, please contact the Managing Director of the company using this form