Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results, and can also include files from any resource on your network.
I have created this step by step guide Installation Guide. Images are used to explain the process easier.
Make sure you have ticked on SSL for Gmail account
Once you configure an Email profile, you can edit using the same way
You also can query and find the Database Mail profile
How to find profile name
SELECT [sa].[account_id]
, [sa].[name] as [Profile_Name]
, [sa].[description]
, [sa].[email_address]
, [sa].[display_name]
, [sa].[replyto_address]
, [ss].[servertype]
, [ss].[servername]
, [ss].[port]
, [ss].[username]
, [ss].[use_default_credentials]
, [ss].[enable_ssl]
FROM
msdb.dbo.sysmail_account sa
INNER JOIN msdb.dbo.sysmail_server ss
ON sa.account_id = ss.account_id
Cheers!
Uma
No comments:
Post a Comment