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 + 'd.sinchuk1993@gmail.com'
EXECUTE msdb.dbo.sysmail_add_account_sp
    @account_name = 'Administrator',
    @description = 'Почтовый аккаунт d.sinchuk1993@gmail.com',
	@replyto_address = 'no-reply@please.no-reply',
    @email_address = @email_address,
    @display_name = @email_address,
    @mailserver_name = 'ДМИТРИЙ-ПК',
	@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