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

*****************************************************************************************
* How to Create an Operator in SQL Server *
*****************************************************************************************
Operators are aliases for people or groups that can receive electronic notification when jobs have completed or alerts have been raised. The SQL Server Agent service supports the notification of administrators through operators. Operators enable notification and monitoring capabilities of SQL Server Agent.

We will be using two ways in SQL Server
1. Using SQL Server management studio graphic user interface GUI Version
2. Using T-SQL script

- Operator in SQL Server -
1. General Settings
2. Notification Settings

/***T-SQL Script to Create an Operator in SQL Server ***/

USE [msdb]
GO

@name=N'DBA',
@enabled=1,
@weekday_pager_start_time=80000,
@weekday_pager_end_time=180000,
@pager_days=62,

GO

@alert_name=N'AlertJobFailStatusToDBAs',
@operator_name=N'DBA',
@notification_method = 1

GO

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#ChiragsTutorial
#DBATutorial
#DBATutorialLearning
#DBAEducation
#DBATutorialFree
#DatabaseTutorial
#SQLServerDatabaseTutorial
#SQLServerDBATutorial
#MicrosoftSQLServerDatabaseTutorial
#ChiragsDBATutorial
#ChiragsDatabaseTutorial
#ChiragsSQLServerDatabaseTutorial
#ChiragsSQLServerDBATutorial
#ChiragsMicrosoftSQLServerDatabaseTutorial
#CreateDatabaseinSQLServer
#CreateDatabasewithT-SQL
#databasetutorial
#sqlserver
#sqlservertutorial
#sqlserver
#sqlservermanagementstudio
#sql_server
#sqlservertutorial
#chiragstutorial
#databasetutorial
#sqlqueries
#sqldba
#database
#databasemanagement