EXEC
msdb.dbo.sp_add_alert
@name=N'AlwaysOn -
Role Change',
@message_id=1480,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=0,
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
--AlwaysOn - Data
Movement Suspended
EXEC
msdb.dbo.sp_add_alert
@name=N'AlwaysOn -
Data Movement Suspended',
@message_id=35264,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=0,
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
--AlwaysOn - Data
Movement Resumed
EXEC
msdb.dbo.sp_add_alert
@name=N'AlwaysOn -
Data Movement Resumed',
@message_id=35265,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=0,
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
Then
create operator
SSMS>
object explorer>sql server agent>operators
No comments:
Post a Comment