Home
  •  

Job step cannot be run because the subsystem failed to load

Microsoft.SQLServer.2000.Job_step_cannot_be_run_because_the_subsystem_failed_to_load (Rule)

Knowledge Base article:

Summary

A specific job step caused SQL Server Agent to write an error to the Windows Application log. The log will show the specific job and job step.

Resolutions

Check the Windows Application log to identify the job step and job that caused the exception. Modify the job step to avoid causing the exception. If the error persists, contact Microsoft Customer Service and Support.

Element properties:

TargetMicrosoft.SQLServer.2000.Agent
CategoryEventCollection
EnabledTrue
Event_ID212
Event Source$Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$
Alert GenerateTrue
Alert SeverityWarning
Alert PriorityNormal
RemotableTrue
Alert Message
Job step cannot be run because the subsystem failed to load
{0}
Event LogApplication
CommentMom2005ID='{F73A0A06-7881-4AEF-A363-1406B8B1D280}'

Member Modules:

ID Module Type TypeId RunAs 
EventDS DataSource Microsoft.Windows.EventProvider Default
GenerateAlert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.SQLServer.2000.Job_step_cannot_be_run_because_the_subsystem_failed_to_load" Target="SQL2000Core!Microsoft.SQLServer.2000.Agent" Enabled="true" Comment="Mom2005ID='{F73A0A06-7881-4AEF-A363-1406B8B1D280}'" Remotable="true">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="EventDS" TypeID="Windows!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>Channel</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>Application</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>212</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>$Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="SystemHealth!System.Health.GenerateAlert">

      <Priority>1</Priority>

      <Severity>1</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2000.Job_step_cannot_be_run_because_the_subsystem_failed_to_load.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDescription$</AlertParameter1>

      </AlertParameters>

    </WriteAction>

  </WriteActions>

</Rule>