|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 6:52 AM
Points: 5,102,
Visits: 20,204
|
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Today @ 8:48 AM
Points: 2,440,
Visits: 714
|
|
Nice question... PBM is new to me. Thanks for the tip.
Jamie
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:43 AM
Points: 165,
Visits: 352
|
|
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.
|
|
|
|
|
SSCarpal Tunnel
       
Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 4,787,
Visits: 1,336
|
|
This is a new to me also.
|
|
|
|
|
SSC-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!!!!!!!!
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 12:43 PM
Points: 7,094,
Visits: 7,152
|
|
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 Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
|
|
|
|