SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Stairway to SQL Server Agent - Step 3: Agent Alerts and Operators


Stairway to SQL Server Agent - Step 3: Agent Alerts and Operators

Author
Message
Richard Waymire
Richard Waymire
SSC-Enthusiastic
SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)

Group: General Forum Members
Points: 145 Visits: 64
Comments posted to this topic are about the item Stairway to SQL Server Agent - Step 3: Agent Alerts and Operators



MDave
MDave
SSC-Enthusiastic
SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)

Group: General Forum Members
Points: 119 Visits: 300
Screenshot 9 is the same as Screenshot 8 Smile
Richard Waymire
Richard Waymire
SSC-Enthusiastic
SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)

Group: General Forum Members
Points: 145 Visits: 64
Indeed, looks like an editing error. I'll email the editors right away and let them know.... In the meantime I attached the correct screenshot here.



Attachments
missing Figure 9.png (16 views, 87.00 KB)
Andy Warren
Andy Warren
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: Moderators
Points: 15015 Visits: 2730
Interesting part on the alerts that don't fire, worth the read right there.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
kalendelaney
kalendelaney
SSC Journeyman
SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)

Group: General Forum Members
Points: 96 Visits: 32
The article should be fixed now..
Thanks for reporting it!

~Kalen



MWise
MWise
Say Hey Kid
Say Hey Kid (684 reputation)Say Hey Kid (684 reputation)Say Hey Kid (684 reputation)Say Hey Kid (684 reputation)Say Hey Kid (684 reputation)Say Hey Kid (684 reputation)Say Hey Kid (684 reputation)Say Hey Kid (684 reputation)

Group: General Forum Members
Points: 684 Visits: 1799
If you can't add a distribution list to your email system, you can add multiple email addresses in the Email Name field for an Operator - just separate them with a semi-colon. That's actually how we have our Admins operator set up.

Thanks,
MWise



Anipaul
Anipaul
SSCrazy Eights
SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)

Group: General Forum Members
Points: 8097 Visits: 1407
Nice one....



bstone-1114579
bstone-1114579
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 29
Forgive me if this has already been addressed, but if I setup an alert like the article shows for severity level 19, will it also alert for anything above that severity level or do I have to setup individual alerts?

I created new topics with this question in the wrong area and can't figure out how to delete those. Sorry.
Richard Waymire
Richard Waymire
SSC-Enthusiastic
SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)SSC-Enthusiastic (145 reputation)

Group: General Forum Members
Points: 145 Visits: 64
One for each severity level. Here's how to test:

--create an alert, using severity 9
EXEC msdb.dbo.sp_add_alert @name=N'RWTest',
@message_id=0,
@severity=9,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=0,
@database_name=N'master',
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'
GO


-- now add a message that will have severity 10 by default

use master;
exec sp_addmessage 50001,10,N'Test Message 50001';

-- fire an event to the windows event log that will have severity 10
exec xp_logevent 50001,'rw test 1',INFORMATIONAL

--now go check the alert -> History tab, and you will see Number of occurrences has NOT incremented

--add an alert to use a severity 10 fire now:

EXEC msdb.dbo.sp_add_alert @name=N'RWTest2',
@message_id=0,
@severity=10,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=0,
@database_name=N'master',
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'


-- fire an event to the windows event log that will have severity 10
exec xp_logevent 50001,'rw test 1',INFORMATIONAL

--now go check the alert -> History tab, and you will see Number of occurrences has incremented


Hope this helps

-Richard



bstone-1114579
bstone-1114579
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 29
Great information Richard!
Is there anyway to "automate" setting up multiple alerts ranging in severity from 19-25?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search