sys.sp_add_operator

general
#stored-procedure

Description

Creates an operator (notification recipient) for use with alerts and jobs.

Syntax

dbo.sp_add_operator
[ @name = ]
N
'name'
[ , [ @enabled = ] enabled ]
[ , [ @email_address = ]
N
'email_address'
]
[ , [ @pager_address = ]
N
'pager_address'
]
[ , [ @weekday_pager_start_time = ] weekday_pager_start_time ]
[ , [ @weekday_pager_end_time = ] weekday_pager_end_time ]
[ , [ @saturday_pager_start_time = ] saturday_pager_start_time ]
[ , [ @saturday_pager_end_time = ] saturday_pager_end_time ]
[ , [ @sunday_pager_start_time = ] sunday_pager_start_time ]
[ , [ @sunday_pager_end_time = ] sunday_pager_end_time ]
[ , [ @pager_days = ] pager_days ]
[ , [ @netsend_address = ]
N
'netsend_address'
]
[ , [ @category_name = ]
N
'category_name'
]
[ ; ]