Policy Based Management (PBM)

Question

Post reply

Policy Based Management (PBM)

Ron McCullough

SSC Guru

Points: 63877
More actions
February 24, 2009 at 11:40 pm

#200696

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[/url]
Before posting a performance problem please read[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jamie-2229 SSCrazy Eights Points: 8156 More actions · Answer 1

Nice question... PBM is new to me. Thanks for the tip.

Jamie

amihalj SSC Enthusiast Points: 167 More actions · Answer 2

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.

Anipaul SSC-Insane Points: 24681 More actions · Answer 3

Anipaul

SSC-Insane

Points: 24681

March 4, 2009 at 11:35 am

#953466

This is a new to me also.

Betim Drenica SSC-Addicted Points: 441 More actions · Answer 4

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!!!!!!!!:w00t:

TomThomson SSC Guru Points: 104773 More actions · Answer 5

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