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

Policy Based Management (PBM) Expand / Collapse
Author
Message
Posted Tuesday, February 24, 2009 11:40 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:02 PM
Points: 5,563, Visits: 24,696
Comments posted to this topic are about the item Policy Based Management (PBM)

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #664029
Posted Wednesday, February 25, 2009 12:54 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, June 28, 2014 8:50 AM
Points: 2,649, Visits: 766
Nice question... PBM is new to me. Thanks for the tip.

Jamie
Post #664555
Posted Thursday, February 26, 2009 7:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 27, 2014 6:10 AM
Points: 167, Visits: 373
Hi,
you can create powershell script to evaluate policy with execution mode OnDemand, and execute that script with SQL Agent job. So, that is solution for OnDemand Policy to run automated.



Post #664992
Posted Wednesday, March 4, 2009 11:35 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,299, Visits: 1,378
This is a new to me also.


Post #668544
Posted Friday, March 20, 2009 3:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 14, 2013 10:48 AM
Points: 121, Visits: 52
Based on BOL the right answer here is wrong.
In BOL is:
There are four evaluation modes, three of which can be automated:
On demand. This mode evaluates the policy when directly specified by the user.
On change: prevent. This automated mode uses DDL triggers to prevent policy violations.
On change: log only. This automated mode uses event notification to evaluate a policy when a relevant change is made.
On schedule. This automated mode uses a SQL Server Agent job to periodically evaluate a policy.

Here is missing On Demand!!!!!!!!
Post #680215
Posted Friday, October 1, 2010 7:49 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 5:53 PM
Points: 8,543, Visits: 9,030
Nice question, Nice clear explanation.

The concept of something that happens "on demand" is automated is somehat amazing, but 37% of replies chose that bizarre concept.


Tom
Post #997134
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse