How to Create an Operator in SQL Server - MS SQL Server DBA Tutorial

In this video you will learn how to create an operator in SQL Server using SQL Server Management Studio as well as using T-SQL Script. It also teaches you how to configure General settings of SQL Server Operator such as work start, work end and configuration of weekend operation. It also help you to configure Notification settings of an Operator such as assigning alerts to an operator. It shows step by step process of creating Operator in SQL Server.

Script to Create an Operator in SQL Server

USE [msdb]

GO

EXEC msdb.dbo.Sp_add_operator
  @name=N'DBA',
  @enabled=1,
  @weekday_pager_start_time=80000,
  @weekday_pager_end_time=180000,
  @pager_days=62,
  @email_address=N'techbrotherssqlage@gmail.com'

GO

EXEC msdb.dbo.Sp_add_notification
  @alert_name=N'JobStatus_DBA',
  @operator_name=N'DBA',
  @notification_method = 1

GO

Create an Operator in SQL Server - MS SQL Server DBA Tutorial

1 comment: