Могу предложить настроить все заново:
---
USE master
GO
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
/****** Object: Operator [MS-SQL-Server-Admins] ******/
IF EXISTS (SELECT name FROM msdb.dbo.sysoperators WHERE name = N'MS-SQL-Server-Admins')
EXEC msdb.dbo.sp_delete_operator @name=N'MS-SQL-Server-Admins'
GO
USE [msdb]
GO
/****** Object: Operator [MS-SQL-Server-Admins] ******/
EXEC msdb.dbo.sp_add_operator @name=N'MS-SQL-Server-Admins',
@enabled=1,
@weekday_pager_start_time=0,
@weekday_pager_end_time=235959,
@saturday_pager_start_time=0,
@saturday_pager_end_time=235959,
@sunday_pager_start_time=0,
@sunday_pager_end_time=235959,
@pager_days=127,
@email_address=N'logs@domen.ru',
@category_name=N'[Uncategorized]'
GO
/*****************************************************************************************/
-- Компонент Database Mail
EXECUTE sp_configure 'show advanced options',1
RECONFIGURE
EXECUTE sp_configure 'Database Mail XPs',1
RECONFIGURE
EXEC sp_configure 'default trace enabled', 0
RECONFIGURE
EXECUTE sp_configure 'show advanced options',0
RECONFIGURE
GO
DECLARE @email_address nvarchar(50)
SELECT @email_address = @@servername + '-MSSQL@domen.ru'
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'Administrator',
@description = 'Mail account for administrative e-mail.',
@replyto_address = 'LOGS@domen.ru',
@email_address = @email_address,
@display_name = @email_address,
@mailserver_name = 'wz-exch1.ad.domen.ru',
@mailserver_type = 'SMTP',
@port = 25,
@use_default_credentials = 0;
GO
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'AlertProfile',
@description = 'Profile used for administrative mail.' ;
GO
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'AlertProfile',
@account_name = 'Administrator',
@sequence_number = 1 ;
GO
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@principal_name = 'public',
@profile_name = 'AlertProfile',
@is_default = 1 ;
GO
/*****************************************************************************************/
USE [msdb]
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @email_save_in_sent_folder=1
GO
EXEC master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE'
, N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent'
, N'UseDatabaseMail'
, N'REG_DWORD', 1
GO
EXEC master.dbo.xp_instance_regwrite N'HKEY_LOCAL_MACHINE'
, N'SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent'
, N'DatabaseMailProfile'
, N'REG_SZ'
, N'AlertProfile'
GO
EXEC master.dbo.sp_MSsetalertinfo @failsafeoperator=N'MS-SQL-Server-Admins',
@notificationmethod=1
GO
---
соответственно измените адреса email, почтового сервера.
MCITP: Database Administrator
