Essentials Data Retention Policy

Microsoft.SystemCenter.DataWarehouse.Essentials.Dataset.DataRetention (DataWarehouseScript)

Sets data retention policy for datasets

Element properties:

Source Code:

<DataWarehouseScript ID="Microsoft.SystemCenter.DataWarehouse.Essentials.Dataset.DataRetention" Accessibility="Internal" DataWarehouseDataSet="DataWarehouse!Microsoft.SystemCenter.DataWarehouse.DataSet.State">

  <Install> 

                    -- update std aggregation retention period

UPDATE StandardDatasetAggregation

SET MaxDataAgeDays = CASE

                       WHEN MaxDataAgeDays &lt;= 37 THEN MaxDataAgeDays

                       ELSE 37

                     END

GO



                    IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='StandardDatasetAggregation_InsertUpdate' AND type='TR')

BEGIN

  EXEC ('CREATE TRIGGER StandardDatasetAggregation_InsertUpdate ON StandardDatasetAggregation AFTER INSERT,UPDATE AS BEGIN RETURN END')

END

GO



ALTER TRIGGER StandardDatasetAggregation_InsertUpdate 

  ON StandardDatasetAggregation 

  AFTER INSERT,UPDATE

AS

BEGIN

  SET NOCOUNT ON

  

  UPDATE StandardDatasetAggregation

  SET MaxDataAgeDays = CASE

                         WHEN MaxDataAgeDays &lt;= 37 THEN MaxDataAgeDays

                         ELSE 37

                       END

END

GO



                    </Install>

  <Uninstall/>

  <Upgrade/>

</DataWarehouseScript>