Home
  •  

Staging Table WF Events job

Microsoft.ApplicationServer.StagingTableWfEventsJob (UnitMonitor)

There is a job that runs periodically to import monitoring events from the temporary (staging) table into the tables that are consumable by tools such as IIS Manager. This monitor checks to make sure that job runs periodically and goes “Red” if it has not been run recently. This indicates that the data visible to the tools is not up to date.

Knowledge Base article:

Summary

There is a job that runs periodically to import monitoring events from the temporary (staging) table into the tables that are consumable by tools such as IIS Manager. This monitor checks to make sure that job runs periodically and goes “Red” if it has not been run recently. This indicates that the data visible to the tools is not up to date.

Resolutions

For SQL Express, ensure that the SQL Broker is enabled. For all other SQL SKUs, ensure that the SQL Agent Service is running.

Element properties:

TargetMicrosoft.ApplicationServer.MonitoringStoreConnectedConnection
Parent MonitorMicrosoft.ApplicationServer.StagingTableJobStatus
CategoryCustom
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeMicrosoft.ApplicationServer.StagingTableJobStatus.MonitorType
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.ApplicationServer.StagingTableWfEventsJob" Accessibility="Public" Enabled="true" Target="MicrosoftApplicationServerLibrary!Microsoft.ApplicationServer.MonitoringStoreConnectedConnection" ParentMonitorID="Microsoft.ApplicationServer.StagingTableJobStatus" Remotable="true" Priority="Normal" TypeID="Microsoft.ApplicationServer.StagingTableJobStatus.MonitorType" ConfirmDelivery="true">

  <Category>Custom</Category>

  <OperationalStates>

    <OperationalState ID="UIGeneratedOpStateIdb8d9521b856e45fb832769a4a1b67102" MonitorTypeStateID="StagingTableJobRunning" HealthState="Success"/>

    <OperationalState ID="UIGeneratedOpStateId588427c3f9dc46319d41c84c477475ed" MonitorTypeStateID="StagingTableJobNotRunning" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <TimeoutSeconds>600</TimeoutSeconds>

    <IntervalSeconds>960</IntervalSeconds>

    <DBIdentity>$Target/Property[Type="MicrosoftApplicationServerLibrary!Microsoft.ApplicationServer.MonitoringStoreConnectedConnection"]/DBIdentity$</DBIdentity>

    <ObjectName>MonitoringStore</ObjectName>

    <CounterName>WfEvents</CounterName>

    <InstanceName>$Data/Property[@Name='DBIdentity']$</InstanceName>

    <Value>$Data/Property[@Name='WfEvents']$</Value>

  </Configuration>

</UnitMonitor>