STEP 1 Create Email Account in SQL Server:
– CREATE ACCOUNT
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = ‘ACCOUNT1′,
@description = ‘Mail account for ACCOUNT1 Database Mail’,
@email_address = ‘EMAIL@ACCOUNT1.co.uk’,
@display_name = ‘SQL EMAIL’,
@username=‘USER’,
@password=‘PASS’,
@mailserver_name = ‘mail.ACCOUNT1.co.uk ‘
STEP 2 Creat Email Profile in SQL Server:
– CREATE PROFILE
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = ‘ACCOUNT1_PROFILE’,
@description = ‘Profile used [...]