Policy Based Management (PBM)

  • 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]

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

    Jamie

  • 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.

  • This is a new to me also.

  • 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:

  • 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

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

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