MSSQL has a service called Database mail and it is used from MSSQL 2005 till today. This service is predecessor of SQL Mail.
I will write about Database mail, and how to set it up.
First of all, you have to open a port 25 (SMTP), so you can send mail from server to the “world”.
Second, we must enable Database Mail
sp_CONFIGURE ‘show advanced’, 1
sp_CONFIGURE ‘Database Mail XPs’, 1
Now, test email settings
EXEC sp_send_dbmail @profile_name=’SQL TEST’,
@body=’Body, Successfully sent an e-mail’
Database Mail, of course saves all outgoing e-mails.
You can check it in msdb database, in tables
And of course you can check the log in table sysmail_log.