Use this script to create alerts for disk I/O errors.
Before running the script replace the <OperatorName> parameter with the actual operator that you would like to alert.
USE msdb
GO
EXEC
msdb. dbo.sp_add_alert @
name
= N
'823 - Read/Write Failure'
,
@message_id = 823,
@severity = 0,
@enabled = 1,
@delay_between_responses = 0,
@include_event_description_in = 1
GO
EXEC
msdb .dbo. sp_add_notification
@alert_name=N
'823 - Read/Write Failure'
,
@operator_name =N
'<OperatorName>'
,
@notification_method = 1;
EXEC
msdb. dbo.sp_add_alert @
name
= N
'824 - Page Error'
,
@message_id = 824,
@severity = 0,
@enabled = 1,
@delay_between_responses = 0,
@include_event_description_in = 1
GO
EXEC
msdb .dbo. sp_add_notification
@alert_name=N
'824 - Page Error'
,
@operator_name =N
'<OperatorName>'
,
@notification_method = 1;
EXEC
msdb. dbo.sp_add_alert @
name
= N
'825 - Read-Retry Required'
,
@message_id = 825,
@severity = 0,
@enabled = 1,
@delay_between_responses = 0,
@include_event_description_in = 1
GO
EXEC
msdb .dbo. sp_add_notification
@alert_name=N
'825 - Read-Retry Required'
,
@operator_name =N
'<OperatorName>'
,
@notification_method = 1;