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
Old Hand
Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)

Group: General Forum Members
Points: 305 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-Addicted
SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)SSC-Addicted (407 reputation)

Group: General Forum Members
Points: 407 Visits: 300
Screenshot 9 is the same as Screenshot 8 Smile
Richard Waymire
Richard Waymire
Old Hand
Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)

Group: General Forum Members
Points: 305 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 (22 views, 87.00 KB)
Andy Warren
Andy Warren
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: Moderators
Points: 40574 Visits: 2770
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-Enthusiastic
SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)SSC-Enthusiastic (164 reputation)

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

~Kalen



MWise
MWise
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1762 Visits: 1820
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
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12611 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
Old Hand
Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)Old Hand (305 reputation)

Group: General Forum Members
Points: 305 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