you can use Database Mail feature of SQL Server to configure and send emails. Operators will help you to send emails to receipients. for DBMail configuration in SQL, you will need an SMTP server with the port enabled to send emails from that server. Also, you will need a Database Mail profile through which the emails will be sent.
Try reading these things in BOL.
Thanks,
Vikas Patil.