Home
  •  

Microsoft FEP 2010 Data Warehouse - Monitor Maintenance Job Completes

Microsoft.Fep2010.Monitoring.FepDataWarehouse.Monitor.MaintenanceJobFailed (UnitMonitor)

This monitors that the last Maintenance job completed successfully.

Knowledge Base article:

Summary

This monitors that the last Maintenance job completed successfully.

Configuration

This monitor is enabled by default and runs every 2 hours.

Causes

The most common causes for Maintenance job failure are:

1. The SQL Database Engine is not running on the FEP 2010 Data Warehouse server or on the System Center Operations Manager database server.

2. The SQL Integration Services on the FEP 2010 Data Warehouse is not installed or is not running.

3. The SQL Analysis Services on the FEP 2010 Data Warehouse is not installed or is not running.

Resolutions

You can do the following to fix the issue:

1. Ensure that the SQL Database Engine is running on the FEP 2010 Data Warehouse and on the System Center Operations Manager database server.

2. Ensure that the SQL Integration Services on FEP 2010 Data Warehouse is installed and running.

3. Ensure that the SQL Analysis Services on FEP 2010 Data Warehouse is installed and running.

Element properties:

TargetMicrosoft.Fep2010.Monitoring.FepDataWarehouse
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
Monitor TypeMicrosoft.Fep2010.Monitoring.Monitoring.DbQueryProbeMonitorType
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.Fep2010.Monitoring.FepDataWarehouse.Monitor.MaintenanceJobFailed" Accessibility="Public" Enabled="true" Target="Microsoft.Fep2010.Monitoring.FepDataWarehouse" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Microsoft.Fep2010.Monitoring.Monitoring.DbQueryProbeMonitorType" ConfirmDelivery="false">

  <Category>AvailabilityHealth</Category>

  <OperationalStates>

    <OperationalState ID="JobPassed" MonitorTypeStateID="Green" HealthState="Success"/>

    <OperationalState ID="JobFailed" MonitorTypeStateID="Red" HealthState="Warning"/>

  </OperationalStates>

  <Configuration>

    <IntervalSeconds>7200</IntervalSeconds>

    <SyncTime/>

    <ConnectionString>Provider=SQLOLEDB;Server=$Target/Host/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlServerConnectionString$;Database=$Target/Host/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlDatabaseName$;Integrated Security=SSPI</ConnectionString>

    <Query>EXEC spAN_Health_GetJobHealthState 'FEP_DataWarehouseMaintenance_$Target/Host/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlDatabaseName$'</Query>

    <QueryTimeout>60</QueryTimeout>

    <GreenFilter>

      <SimpleExpression>

        <ValueExpression>

          <XPathQuery Type="Integer">Columns/Column[2]</XPathQuery>

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

          <Value Type="Integer">1</Value>

        </ValueExpression>

      </SimpleExpression>

    </GreenFilter>

    <RedFilter>

      <SimpleExpression>

        <ValueExpression>

          <XPathQuery Type="Integer">Columns/Column[2]</XPathQuery>

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

          <Value Type="Integer">2</Value>

        </ValueExpression>

      </SimpleExpression>

    </RedFilter>

  </Configuration>

</UnitMonitor>