How to make an SQL server send email?

To make your SQL server send email: The most straightforward way to send emails from SQL Server is by creating a new SQL Agent Job and setting SQL to send emails about the job's status. For that, you can use the profile you just created. To set up, you can use another simple Wizard. You need to first configure DB mail in SQL Server in order to utilise this functionality. You can use the below link as a reference for DB mail configuration purposes. https://www.brentozar.com/blitz/database-mail-configuration/ Once DB mail is set up, you can enable database mail on SQL Server Agent. The same link describes how to do that. Once it is enabled on SQL Server Agent, you need to restart the SQL Server Agent service to make that take effect. That's it. Now you can use the msdb.dbo.sp_send_dbmail SP to send email using a SQL Server Agent job or a stored procedure.