You must first configure Database Mail in SQL Server. Once you do that, you can send an email at anytime using this syntax: EXEC msdb.dbo.sp_send_dbmail @profile_name='Devin Johnson', @recipients='djohnson@dyntools.com; djohnson@icbconsulting.com', @subject='Test email', @body='This is an example email.' To make it an HTML formatted email, add: @body_format='HTML' |
SQL Server >