syspolicy_policy_execution_history (Transact-SQL)
Applies to: SQL Server
Displays the time when policies were executed, the result of each execution, and details about errors if any occurred. The following table describes the columns in the syspolicy_policy_execution_history view.
Column name | Data type | Description |
---|---|---|
history_id | bigint | Identifier of this record. Each record indicates a policy and one time that it was initiated. |
policy_id | int | Identifier of the policy. |
start_date | datetime | Date and time this policy tried to run. |
end_date | datetime | Time this policy finished running. |
result | bit | Success or failure of the policy. 0 = Failure, 1 = Success. |
exception_message | nvarchar(max) | Message generated by the exception if one occurred. |
exception | nvarchar(max) | Description of the exception if one occurred. |
Remarks
The syspolicy_policy_execution_history_details view contains related details about the targets of the policy and the condition expressions tested.
Permissions
Requires membership in the PolicyAdministratorRole role in the msdb database.
See Also
Administer Servers by Using Policy-Based Management
Policy-Based Management Views (Transact-SQL)
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για