Set Up a SQL Server Database Alert
Connect to the instance using Microsoft SQL Management Studio
Double Click SQL Server Agent
Right Click on Operators and select New Operator
USE [msdb]
GO
/****** Object: Operator [ DBA] Script Date: 6/9/2015 5:50:44 AM ******/
EXEC msdb.dbo.sp_add_operator @name=N' DBA',
@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'xxyy@z.com,
@category_name=N'[Uncategorized]'
GO
Double Click SQL Server Agent
Right Click on Operators and select New Operator
GO
/****** Object: Operator [ DBA] Script Date: 6/9/2015 5:50:44 AM ******/
EXEC msdb.dbo.sp_add_operator @name=N' DBA',
@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'xxyy@z.com,
@category_name=N'[Uncategorized]'
GO
Comments
Post a Comment