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 1234»»»

PBM Alert Expand / Collapse
Author
Message
Posted Friday, July 22, 2011 12:07 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:18 AM
Points: 21,221, Visits: 14,922
Comments posted to this topic are about the item PBM Alert



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1146424
Posted Friday, July 22, 2011 4:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 3, 2013 1:55 AM
Points: 298, Visits: 236
Nice question! Got me researching on Alerts, Roles and Policies before I answered and got it right
Post #1146496
Posted Friday, July 22, 2011 5:15 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 19, 2014 2:44 AM
Points: 549, Visits: 1,016
Am I doing this wrong? (QotD) Even if its a subject I don't know about I try and come up with an answer as its a test of my knowledge. I don't look up the answers beforehand.

Does everyone else treat them like a real life scenario at work where you books online anything you dont know?
Post #1146523
Posted Friday, July 22, 2011 5:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 18, 2014 4:54 AM
Points: 2,085, Visits: 1,691
No, not everybody

But, if you've been following the discussions on some recent questions you'll note that some people take the prospect of a point very seriously.

I think the honourable approach is to try and answer the question straight away then, especially if you get it wrong. read the given reference and learn something.

But that's just me - people are free to approach the scenario as best suits them. Invariably nobody gets hurt.
Post #1146537
Posted Friday, July 22, 2011 5:33 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:07 AM
Points: 1,765, Visits: 2,139
Excellent question. Thanks Jason!

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1146539
Posted Friday, July 22, 2011 5:42 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Thanks for the question.

http://brittcluff.blogspot.com/
Post #1146549
Posted Friday, July 22, 2011 5:47 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 3,859, Visits: 5,001
This was quite a headscratcher.
thanks, Jason, learned something today.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1146555
Posted Friday, July 22, 2011 5:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
Hey, wait a second. According to:

http://technet.microsoft.com/en-us/library/bb510667.aspx

Administering Policy-Based Management requires membership in the PolicyAdministratorRole role in the msdb database. This role has complete control of all policies on the system. This control includes creating and editing policies and conditions and enabling and disabling policies.

So tell me why did I get it wrong?
Post #1146556
Posted Friday, July 22, 2011 6:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:27 AM
Points: 2,517, Visits: 3,711
Shark Energy (7/22/2011)
Am I doing this wrong? (QotD) Even if its a subject I don't know about I try and come up with an answer as its a test of my knowledge. I don't look up the answers beforehand.

Does everyone else treat them like a real life scenario at work where you books online anything you dont know?


Some consider it cheating to look up answer but I tell interviewers that I know how to get the information if I don't know it off the top of my head.

One can't know everything. The skill to research and find solutions is as valuable as knowing the answer. If I don't know an interview question I always explain how I would find it. In DBI (days before internet) I knew which hard copy manual had the answer. Today, it's about knowing where to look on the WWW. Of course, in an interview, if 80% of your answers are "I'll look it up", you're not qualified for the job.

It's more how you look at these QotD's. I don't consider the points to be of value. I really don't care about them. QotD's are a valuable tool to learn. At least to me.
Post #1146574
Posted Friday, July 22, 2011 6:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 21, 2014 10:07 AM
Points: 1,260, Visits: 3,545
cengland0 (7/22/2011)
Hey, wait a second. According to:

http://technet.microsoft.com/en-us/library/bb510667.aspx

Administering Policy-Based Management requires membership in the PolicyAdministratorRole role in the msdb database. This role has complete control of all policies on the system. This control includes creating and editing policies and conditions and enabling and disabling policies.

So tell me why did I get it wrong?

He mentions testing the alert before pushing to production which indicates an on-demand test. Reading further in the link you'll see
"Alert security:

When policies are evaluated on demand, they execute in the security context of the user. To write to the error log, the user must have ALTER TRACE permissions or be a member of the sysadmin fixed server role. Policies that are evaluated by a user that has less privileges will not write to the event log, and will not fire an alert."

Although sysadmin will work, it's not the minimum permission


______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
Post #1146587
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse