EXEC msdb.dbo.sp_add_alert @name=N'1480 - AG Role Change', 
        @message_id=1480, 
        @severity=0, 
        @enabled=1, 
        @delay_between_responses=1, 
        @include_event_description_in=1, 
        @category_name=N'[Uncategorized]', 
        @job_id=N'00000000-0000-0000-0000-000000000000'
GO

EXEC msdb.dbo.sp_add_alert @name=N'35264 - AG Data Movement - Suspended', 
        @message_id=35264, 
        @severity=0, 
        @enabled=1, 
        @delay_between_responses=1, 
        @include_event_description_in=1, 
        @category_name=N'[Uncategorized]', 
        @job_id=N'00000000-0000-0000-0000-000000000000'
GO

EXEC msdb.dbo.sp_add_alert @name=N'35265 - AG Data Movement - Resumed', 
        @message_id=35265, 
        @severity=0, 
        @enabled=1, 
        @delay_between_responses=1, 
        @include_event_description_in=1, 
        @category_name=N'[Uncategorized]', 
        @job_id=N'00000000-0000-0000-0000-000000000000'
GO

EXEC msdb.dbo.sp_add_alert @name=N'41404 - AG is offline', 
        @message_id=41404, 
        @severity=0, 
        @enabled=1, 
        @delay_between_responses=1, 
        @include_event_description_in=1, 
        @category_name=N'[Uncategorized]', 
        @job_id=N'00000000-0000-0000-0000-000000000000'
GO

EXEC msdb.dbo.sp_add_alert @name=N'41405 - AG is not ready for automatic failover', 
        @message_id=41405, 
        @severity=0, 
        @enabled=1, 
        @delay_between_responses=1, 
        @include_event_description_in=1, 
        @category_name=N'[Uncategorized]', 
        @job_id=N'00000000-0000-0000-0000-000000000000'
GO