http://computertriksno1.blogspot.in/

Configuring Database Mail Using T-SQL Script

24 Oct 2017 4 comments

Configuring Database Mail Using T-SQL Script


--Enabling Database Mail
sp_configure 'show advanced options',1
reconfigure
go
sp_configure 'Database Mail XPs',1
reconfigure
go


--Creating a Profile
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'SQLMailProfile',
@description = 'Mail Service for SQL Server' ;
go


-- Create a Mail account for gmail. We have to use our company mail account.
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'SQL_Email_Account',
@email_address = 'computertrik@gmail.com',
@mailserver_name = 'smtp.gmail.com',
@port=587,
@enable_ssl=1,
@username='computertrik@gmail.com',
@password='Emailid password'
go


-- Adding the account to the profile
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'SQLMailProfile',
@account_name = 'SQL_Email_Account',
@sequence_number =1 ;
go


-- Granting access to the profile to the DatabaseMailUserRole of MSDB
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'SQLMailProfile',
@principal_id = 0,
@is_default = 1 ;
go

--Sending Test Mail
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SQLMailProfile',
@recipients = 'youremailid@xxxx.com',
@body = 'Database Mail Testing...',
@subject = 'Databas Mail from SQL Server';
go

--Verifying, check status column
select * from sysmail_allitems
go

Summary 
Database Mail feature was introduced in SQL Server 2005 version, which can be used to notify the administrators/operators. It provides better performance as well as cluster aware feature.     
Share this article :

+ comments + 4 comments

5 November 2017 at 09:05

You can watch on YouTube => Click Here

!!!Demo!!! Thanks For sharing. Its look there are new & very Important Artical Here.
This blog help me very Much. Thanks again.
Go Ahead, we are always with You. and Share More & More Updates Like This. !!!Demo!!!

22 December 2017 at 15:30

You can watch on YouTube => Click Here

!!!Demo!!! Vợ chồng Gia Bảo – Thanh Hiền, đôi tình nhân Huỳnh Anh – Hoàng Oanh… gây tiếc nuối khi chia tay sau nhiều năm gắn bó. Nhiều sao Việt ly hôn, chia tay trong năm 2017 !!!Demo!!!

26 December 2017 at 13:30

You can watch on YouTube => Click Here

!!!Demo!!! Giảm cân thú vị với nguyên liệu dưa gang
Theo các chuyên gia thì dưa gang là loại thực phẩm có tính hàn vị ngọ nên có thể hỗ trợ giải khát rất tốt. Những nghiên cứu cũng đã chứng minh được rằng dưa gang cũng có thể giúp bạn vừa giảm cân và duy trì được cân nặng ở trạng thái khỏe mạnh, an toàn. !!!Demo!!!

Post a Comment

 
Support : GDDon | Creating Website | Gddon |
Copyright © 2013. Computer Tricks and Tips for System - All Rights Reserved
Template Created by Creating Website Modify by GDDon.Com
Proudly powered by Blogger