You can configure a SQL Server mail profile so you can send and receive e-mail by running Transact-SQL code (for example, by using the xp_sendmail extended stored procedure to send e-mail). You can also configure a mail profile for SQL Server Agent so that e-mail will be sent to operators automatica
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help