August 11, 2005 at 1:41 pm
I have created alerts for severity levels and not all are firing.
I am interested in severity 16, I get ones for severity level 10.
I have view the sysmessages table to idntify the severity level.
FOr instance when I take the database offline, I should receive an alert. I do not receive anything? All alerts are enabled.
Also,
have defined an alert for error # 15327 which is for 'the database is now offline', for the database name i have 'all databases'. when i take the database offline this alert is not initiated (the alert is in the enable state), am i missing anything ?
August 15, 2005 at 7:28 pm
HI,
Have u checked that under what database ur job is scheduled.
Hope this helps u.
from
Killer
August 17, 2005 at 4:18 pm
these are standard SqlServer standard alerts. They should fire when the error number is reached,
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply