Send email from sqlexpress

EXECUTE msdb.dbo.sysmail_add_account_sp --sysmail_add_account_sp --sysmail_update_account_sp
@account_name = 'eDoc',
@description = 'Sent Mail using MSDB',
@email_address = 'info@helpdesk.co.ba',
@display_name = 'eDoc',
@username='info@helpdesk.co.ba',
@password='************',
@mailserver_name = 'mail.helpdesk.co.ba',
@port = '26'

EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'eDoc',
@description = 'Profile used to send mail'

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'eDoc',
@account_name = 'eDoc',
@sequence_number = 1


EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'eDoc',
@principal_name = 'public',
@is_default = 1 ;


sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO

--SELECT *FROM msdb.dbo.sysmail_account
--SELECT *FROM msdb.dbo.sysmail_configuration
--SELECT *FROM msdb.dbo.sysmail_principalprofile
--SELECT *FROM msdb.dbo.sysmail_profile
--SELECT *FROM msdb.dbo.sysmail_profileaccount
--SELECT *FROM msdb.dbo.sysmail_profileaccount

exec msdb.dbo.sp_send_dbmail @profile_name = 'eDoc', @recipients = 'info@helpdesk.co.ba', @subject = 'Veleprodaja', @body = 'Mail Sent Successfully', @body_format = 'text'

Detalji članka

ID članka:
6
Kategorija:
Ocjena :

Vezani članci