On Demand: When you choose this execution mode, the policy will be evaluated when the user manually runs the policy. Except for this policy execution mode, all other policy execution modes are automated.
On Schedule: Choosing this execution mode allows you to define a schedule when the policy will be evaluated automatically. The automatic evaluation of the policy is carried out by a SQL Server Agent job. This mode is an automated mode and logs any violations of the policy in the Windows Event log.
On Change-Log Only: With this mode, the policy is evaluated only when a relevant change occurs. This mode is also automated and logs any violations of the policy.
On Change-Prevent: With this mode, the policy is evaluated when a relevant change occurs in the associated target entity. This mode also prevents policy violations by using DDL triggers.
No comments:
Post a Comment