You are the database administrator for your company. You have been assigned the task of managing alerts andissuing notifications for events occurring in the database.
John is a new employee in the organization. You add an operator for John by using the following Transact-SQL batch:
EXECUTE dbo.sp_add_operator
@name = ‘John’,
@enabled = 1,
@email_address = ‘john@esoft.com’,
@weekday_pager_start_time = 070000,
@weekday_pager_end_time = 200000,
@pager_days = 10,
@pager_address = ‘568923@pager.esoft.com’; GO
You want John to be notified each time the alert named Alert1 is generated. To add the notification, you issue thefollowing Transact-SQL batch:
EXECUTE dbo.sp_add_notification
@alert_name = ‘Alert1’,
@operator_name = ‘John’,
@notification_method = 1; GO
exhibit Which statement is true of the notification received by John for the Alert1 alert?