Class PolicyBasedManagementSchema.PolicyExecutionHistory

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

syspolicy_policy_execution_history (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

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.

See dbo.syspolicy_policy_execution_history.

[Table(Database = "msdb", Schema = "dbo", Name = "syspolicy_policy_execution_history", IsView = true)]
public class PolicyBasedManagementSchema.PolicyExecutionHistory

Inheritance

object

PolicyBasedManagementSchema.PolicyExecutionHistory

Extension Methods

Map.DeepCopy<T>(T)

Properties

EndDate

Time this policy finished running.

[Column("end_date")]
[NotNull]
public DateTime EndDate { get; set; }

Property Value

DateTime

Exception

Description of the exception if one occurred.

[Column("exception")]
[NotNull]
public string Exception { get; set; }

Property Value

string

ExceptionMessage

Message generated by the exception if one occurred.

[Column("exception_message")]
[NotNull]
public string ExceptionMessage { get; set; }

Property Value

string

HistoryID

Identifier of this record. Each record indicates a policy and one time that it was initiated.

[Column("history_id")]
[NotNull]
public long HistoryID { get; set; }

Property Value

long

PolicyID

Identifier of the policy.

[Column("policy_id")]
[NotNull]
public int PolicyID { get; set; }

Property Value

int

Result

Success or failure of the policy. 0 = Failure, 1 = Success.

[Column("result")]
[NotNull]
public bool Result { get; set; }

Property Value

bool

StartDate

Date and time this policy tried to run.

[Column("start_date")]
[NotNull]
public DateTime StartDate { get; set; }

Property Value

DateTime