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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Richard Waymire » Stairway to SQL Server Agent - Step 3: Agent...

14 posts, Page 1 of 2

1 2 »»

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

Rate Topic

Display Mode

Topic Options

Author

Message

Richard Waymire

Posted Tuesday, March 22, 2011 12:08 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 12:29 PM
Points: 11, Visits: 52

Comments posted to this topic are about the item Stairway to SQL Server Agent - Step 3: Agent Alerts and Operators

Post #1082213

David.Maron

Posted Wednesday, June 29, 2011 1:48 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:07 AM
Points: 37, Visits: 257

Screenshot 9 is the same as Screenshot 8 :)

Post #1133471

Richard Waymire

Posted Wednesday, June 29, 2011 7:15 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 12:29 PM
Points: 11, Visits: 52

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.

Post Attachments

missing Figure 9.png (8 views, 87.30 KB)

Post #1133709

Andy Warren

Posted Wednesday, June 29, 2011 7:54 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Interesting part on the alerts that don't fire, worth the read right there.

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #1133742

kalendelaney

Posted Wednesday, June 29, 2011 10:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, December 02, 2012 4:19 PM
Points: 4, Visits: 31

The article should be fixed now..
Thanks for reporting it!

~Kalen

Post #1133872

MWise

Posted Wednesday, June 29, 2011 2:04 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 20, 2013 9:31 AM
Points: 381, Visits: 1,481

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

Post #1134074

Anipaul

Posted Monday, July 04, 2011 7:38 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 1:35 AM
Points: 4,789, Visits: 1,336

Nice one....

Post #1135965

bstone-1114579

Posted Saturday, February 18, 2012 9:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 8:06 AM
Points: 6, 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.

Post #1254332

Richard Waymire

Posted Saturday, February 18, 2012 2:31 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 12:29 PM
Points: 11, Visits: 52

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

Post #1254380

bstone-1114579

Posted Tuesday, February 21, 2012 6:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 8:06 AM
Points: 6, Visits: 29

Great information Richard!
Is there anyway to "automate" setting up multiple alerts ranging in severity from 19-25?

Post #1255233

« Prev Topic | Next Topic »

14 posts, Page 1 of 2

1 2 »»

Permissions