USE msdb
GO
sp_send_dbmail @profile_name='DatabaseMail_ProfileName',
@recipients='XXXXXXXX@yourdomain.com',
@subject='Test message',
@body='This is the body of the test message. Congrates Database Mail Received By you Successfully.'