July 12, 2016 at 7:48 am
Hello folks!
I've been trying to add an alert to be sent on when AG (Role change) or (AG Data Movement - Suspended) or (AG Data Movement - Resumed), but its not working.
when im checking the logs, i dont see any logs related to these error numbers in the logs(logs are attached).
As per my understanding, alerts are triggered against errors in logs(is that correct?) if yes, i dont see any logs for (1480, 35264 ,35265) error numbers. Is there a way to enable logging those errors? how?
---------- Script ----------
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'AG Role Change',
@message_id=1480,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'AG Role Change', @operator_name=N'XXX', @notification_method = 1
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'AG Data Movement - Suspended',
@message_id=35264,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'AG Data Movement - Suspended', @operator_name=N'XXX', @notification_method = 1
GO
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'AG Data Movement - Resumed',
@message_id=35265,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'AG Data Movement - Resumed', @operator_name=N'XXX', @notification_method = 1
GO
---------- Script ----------
July 12, 2016 at 8:50 am
It looks like you have cribbed the code from here ..https://www.mssqltips.com/sqlservertip/3489/configure-sql-server-alerts-and-notifications-for-alwayson-availability-groups/
...have you updated the job_id to your specific job ids in your code?
If not use the link as a reference
Hope this helps
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy