Send mail from Database

Step1 : configure profile and account in SQL server under SQL Management  Database Mail


Step2: Do the below configurations

sp_CONFIGURE 'show advanced', 1
GO
RECONFIGURE
GO
sp_CONFIGURE 'Database Mail XPs', 1
GO
RECONFIGURE
Step3 : Send one test mail

EXEC sp_send_dbmail @profile_name='DBMAILProfilename',

@recipients='example@server.com',

@subject='Test message',

@body='This is the body of the test message.

Congrates Database Mail Received By you Successfully.'

Sending sample mail

Ref : http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/