mssql을 활용하여 메일전송하기[펌]

EXECUTE msdb.dbo.sysmail_add_account_sp

@account_name = 'MailServiceAccount'

, @description = 'DataBaser.Net Service Mail'

, @email_address = 'admin@databaser.net'

, @display_name = 'Databaser.Net'

, @username='admin@databaser.net'

, @password='패스워드'

, @mailserver_name = 'mail.databaser.net'

EXECUTE msdb.dbo.sysmail_add_profile_sp

@profile_name = 'MailServiceProfile'

, @description = 'Profile used for database mail';

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp

@profile_name = 'MailServiceProfile'

, @account_name = 'MailServiceAccount'

, @sequence_number = 1

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp

@profile_name = 'MailServiceProfile'

, @principal_name = 'public'

, @is_default = 1 ;

/*

--참고: 지우기

EXECUTE msdb.dbo.sysmail_delete_profileaccount_sp

@profile_name = 'MailServiceProfile'

, @account_name = 'MailServiceAccount'

EXECUTE msdb.dbo.sysmail_delete_profile_sp

@profile_name = 'MailServiceProfile' ;

EXECUTE msdb.dbo.sysmail_delete_account_sp

@account_name = 'MailServiceAccount' ;

--exec msdb..sysmail_help_principalprofile_sp

EXECUTE msdb.dbo.sysmail_delete_principalprofile_sp

@principal_name = 'guest',

@profile_name = 'MailServiceProfile' ;

*/

--메일보내기

declare @body1 varchar(100)

set @body1 = 'Server :'+@@servername+ ' My First Database Email '

EXEC msdb.dbo.sp_send_dbmail

@recipients='admin@databaser.net'

, @subject = 'My Mail Test'

, @body = @body1

, @body_format = 'HTML' ;

출처:[MS-SQL] SQL Server 2005 데이터베이스 메일 보내기 [펌]