February 24, 2009 at 11:40 pm
Comments posted to this topic are about the item Policy Based Management (PBM)
February 25, 2009 at 12:54 pm
Nice question... PBM is new to me. Thanks for the tip.
Jamie
February 26, 2009 at 7:17 am
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.
March 4, 2009 at 11:35 am
This is a new to me also.
March 20, 2009 at 3:21 am
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:
October 1, 2010 at 7:49 pm
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