Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Stairway to SQL Server Agent - Step 3: Agent Alerts and Operators Expand / Collapse
Author
Message
Posted Tuesday, March 22, 2011 12:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 30, 2014 11:41 AM
Points: 11, Visits: 62
Comments posted to this topic are about the item Stairway to SQL Server Agent - Step 3: Agent Alerts and Operators


Post #1082213
Posted Wednesday, June 29, 2011 1:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 16, 2014 1:24 PM
Points: 39, Visits: 285
Screenshot 9 is the same as Screenshot 8 :)
Post #1133471
Posted Wednesday, June 29, 2011 7:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 30, 2014 11:41 AM
Points: 11, Visits: 62
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 (9 views, 87.30 KB)
Post #1133709
Posted Wednesday, June 29, 2011 7:54 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Monday, November 17, 2014 2:20 PM
Points: 6,800, Visits: 1,914
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
Post #1133742
Posted Wednesday, June 29, 2011 10:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 29, 2013 5:47 PM
Points: 4, Visits: 32

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

~Kalen



Post #1133872
Posted Wednesday, June 29, 2011 2:04 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 17, 2014 7:59 PM
Points: 395, Visits: 1,610
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
Posted Monday, July 4, 2011 7:38 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,439, Visits: 1,400
Nice one....


Post #1135965
Posted Saturday, February 18, 2012 9:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Saturday, February 18, 2012 2:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 30, 2014 11:41 AM
Points: 11, Visits: 62
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
Posted Tuesday, February 21, 2012 6:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase 12»»

Permissions Expand / Collapse