Regola di pulitura delle informazioni sullo stato processi del data warehouse

Microsoft.SystemCenter.DataWarehouse.Synchronization.JobStatusGrooming (Rule)

Questa regola elimina i dati dalla tabella Change Tracking Agent e Change Tracking Reset Monitor.

Element properties:

Member Modules:

Source Code:

<Rule ID="Microsoft.SystemCenter.DataWarehouse.Synchronization.JobStatusGrooming" Target="Microsoft.SystemCenter.DataWarehouseSynchronizationService" Enabled="true" ConfirmDelivery="true">

  <Category>System</Category>

  <DataSources>

    <DataSource ID="TimerDataSource" TypeID="Microsoft.SystemCenter.DataWarehouse.Synchronization.JobStatusGroomingDataSource">

      <ChangeTrackingGroomingFrequencyMinutes>1440</ChangeTrackingGroomingFrequencyMinutes>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WA" TypeID="Microsoft.SystemCenter.DataWarehouse.Synchronization.JobStatusGroomingWriter">

      <ManagementGroupId>$Target/ManagementGroup/Id$</ManagementGroupId>

      <SynchronizationProcessId>$MPElement$</SynchronizationProcessId>

      <ChangeTrackingAgentAgeDays>400</ChangeTrackingAgentAgeDays>

      <ChangeTrackingResetMonitorAgeDays>400</ChangeTrackingResetMonitorAgeDays>

      <SqlAuthentication>

        <Login>$RunAs[Name="DataWarehouse!Microsoft.SystemCenter.DataWarehouse.SqlAuthenticationActionAccount"]/UserName$</Login>

        <Password>$RunAs[Name="DataWarehouse!Microsoft.SystemCenter.DataWarehouse.SqlAuthenticationActionAccount"]/Password$</Password>

      </SqlAuthentication>

    </WriteAction>

  </WriteActions>

</Rule>