Home
  •  

Microsoft FEP 2010 Data Warehouse - Monitor Data-up Job Exists

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

This monitors whether the Data-up job is installed.

Knowledge Base article:

Summary

This monitors whether the Data-up job is installed.

Configuration

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

Causes

The most common cause for the Data-up job to not be installed is that someone deleted it.

Resolutions

To fix the problem, run the Uninstall and then install the FEP 2010 Reports feature. During the installation, make sure you select the Database reuse option.

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.DataUpJobExists" 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="JobExists" MonitorTypeStateID="Green" HealthState="Success"/>

    <OperationalState ID="JobNotExists" MonitorTypeStateID="Red" HealthState="Error"/>

  </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_GetNewData_$Target/Host/Property[Type="Microsoft.Fep2010.Monitoring.FepDataWarehouseContainer"]/DataWarehouseSqlDatabaseName$'</Query>

    <QueryTimeout>60</QueryTimeout>

    <GreenFilter>

      <SimpleExpression>

        <ValueExpression>

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

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

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

        </ValueExpression>

      </SimpleExpression>

    </GreenFilter>

    <RedFilter>

      <SimpleExpression>

        <ValueExpression>

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

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

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

        </ValueExpression>

      </SimpleExpression>

    </RedFilter>

  </Configuration>

</UnitMonitor>