Configure Database Mail - Send Email From SQL Database

http://www.codeproject.com/Articles/29060/SQL-SERVER-2008-Configure-Database-Mail-Send-Email

1. create profile
2.  configure email
     run this code for configure
    sp_CONFIGURE 'show advanced', 1
   GO
   RECONFIGURE
   GO
   sp_CONFIGURE 'Database Mail XPs', 1
   GO
   RECONFIGURE
   GO
3. Send mail

EXEC sp_send_dbmail @profile_name='Test',
@recipients='test@example.com',
@subject='Test message',
@body='This is the body of the test message. sent through DataBase mail'