RemovalPolicies View (Repository.Item Schema)
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
Stores removal policies used by Modeling Services lifetime services.
Fields
The following table lists the fields in the RemovalPolicies view.
| Column | Type | Required | Description |
|---|---|---|---|
Id |
int |
yes |
The identifier of the removal policy. |
Name |
yes |
The name of the removal policy. |
|
Schedule |
sysname |
yes |
The name of an existing database job schedule. This schedule determines when to run the removal policy. |
Rule |
nvarchar(max) |
yes |
An expression that determines what data is removed when the removal policy runs. |
LastTimeStamp |
timestamp |
A timestamp field that marks the last run of the removal policy. |