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 |