Lifetime Services Tasks (Modeling Services)

[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.]

Lifetime Services automatically removes old rows from SQL Server Modeling Services tables based on Lifetime policies.

Lifetime Services Overview

The [Repository.Item].[RemovalPolicies] view contains a list of Lifetime policies. You can add custom Lifetime policies to this view that specify a policy name, a schedule for running the policy, and a rule that determines which rows are deleted. Policies are applied to tables using SQL Server extended properties. This means that you can apply different policies to different tables depending on the business requirements for data retention.

Typically, schema developers create lifetime policies during the model schema development. Modeling Services administrators can later choose to modify the lifetime policies to comply with changing business requirements.

In This Section

How to: Create a Lifetime Policy explains how to perform Lifetime Services tasks in the Modeling Services database.

See Also

Concepts

SQL Server Modeling Services Administration
SQL Server Modeling Services Architecture