use [master];
GO
/* Create database mail account
*/
exec msdb.dbo.sysmail_add_account_sp
@account_name = 'My Gmail account'
, @email_address = 'youraccount@gmail.com'
, @mailserver_name = 'smtp.gmail.com'
, @port = 587
, @enable_ssl = 1;
GO
/* Create database mail profile
*/
exec msdb.dbo.sysmail_add_profile_sp
@profile_name = 'Database Mail profile';
GO
/* Associate Database Mail profile with the account My Gmail account
*/
exec msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'Database Mail profile'
, @account_name = 'My Gmail account'
, @sequence_number = 1;
GO
/* Enable Database Mail
*/
exec sp_configure 'show advanced options',1
reconfigure
GO
exec sp_configure 'Database Mail XPs',1
reconfigure
GO