Email on a bEach
3 oz vodka
1 oz peach schnapps
4 oz cranberry juice
4 oz orange juice
Simply put, you get the mail profile, and use a MSSQL procedure to send it.
Here is an example where a query is passed.
-- if there is a return on the above select, insert the results and send an email showing the results. IF @@ROWCOUNT > 0 BEGIN -- Email the results if a new record appears. EXEC msdb.dbo.sp_send_dbmail @profile_name = 'JobStatus', @recipients = 'DBAdmin@yourbusiness.com', @body = 'There are new records in the table.', @subject = 'New record that requires yoru attention.', @query = ' SELECT * from tblWithData where isNew = 1 ' END