3

How to send email from SQL Server Jobs in SQL Server 2014. I want to implement email notification through stored procedure instead of Windows services.

migrated from stackoverflow.com Jul 4 '16 at 12:46

This question came from our site for professional and enthusiast programmers.

  • What kind of e-mail notification You are thinking about? If it's something other than db maintenance or alerts, then database mail is ok. Otherwise - stick with something else. – Marcin S. Jul 4 '16 at 12:53
4

You need to first configure DB mail in SQL Server in order to utilise this functionality. You can use below link as a referece for DB mail configuration purposes.

https://www.brentozar.com/blitz/database-mail-configuration/

Once DB mail is setup 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 msdb.dbo.sp_send_dbmail SP to send email using SQL Server Agent job or stored procedure.

2

First Setup a Database Mail account, Database Mail profile and use the below code in your SP.

EXEC msdb.dbo.sp_send_dbmail 
@profile_name='Mymail', 
@recipients='MYmail@company.com',
@subject = 'Mail subject' ,
@body = 'Mail body' ,
@file_attachments  = 'G:\BACKUP\data\log.txt' --Path to attachment if any

You can always refer to MSDN for more options

https://msdn.microsoft.com/en-us/library/ms190307.aspx

1

You can send the email(s) by using the SQL Server's extended stored procedure sp_send_dbmail.
Look here for the documentation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy