Situatie
Mai jos este un script care poate fi folosit la adaugarea unui operator pe un server MSSQL. Operatorii sunt folositi pentru a se trimite/receptiona diferite alerte/evenimente.
Solutie
USE msdb;
GO
declare @NumeOperator varchar(max)
declare @EmailOperator varchar(max)
set @NumeOperator = ‘aici se pune numele opearatorului a carui definire se doreste’
set @EmailOperator = ‘aici se pune emailul opearatorului a carui definire se doreste’
IF NOT EXISTS (SELECT name FROM msdb.dbo.sysoperators WHERE name = @NumeOperator)
EXEC msdb.dbo.sp_add_operator
@name=@NumeOperator,
@enabled=1,
@weekday_pager_start_time=90000,
@weekday_pager_end_time=180000,
@saturday_pager_start_time=90000,
@saturday_pager_end_time=180000,
@sunday_pager_start_time=90000,
@sunday_pager_end_time=180000,
@pager_days=0,
@email_address=@EmailOperator,
@category_name=N'[Uncategorized]’
GO
USE msdb;
GO
EXEC master.dbo.sp_MSsetalertinfo @failsafeoperator=@NumeOperator
GO
USE msdb;
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @email_save_in_sent_folder=1
GO
Leave A Comment?