Home
  •  

Auto-interruzione di SQL Server Agent in corso

Microsoft.SQLServer.2008.SQLServerAgent_initiating_self_termination_1_5_Rule (Rule)

Knowledge Base article:

Riepilogo

SQL Server Agent ha arrestato il servizio SQL Server Agent.

Cause

Ciò può essere dovuto a un hardware o software difettoso presente sul server.

Soluzioni

Esaminare i log degli errori di sistema e il log di SQL Server Agent per individuare gli errori che erano stati generati prima dell'arresto di SQL Server Agent provocato da se stesso. Risolvere il problema che ha causato l'errore iniziale e riavviare il servizio SQL Server Agent.

Element properties:

TargetMicrosoft.SQLServer.2008.Agent
CategoryEventCollection
EnabledTrue
Event_ID51
Event Source$Target/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$
Alert GenerateTrue
Alert SeverityWarning
Alert PriorityNormal
RemotableTrue
Alert Message
Auto-interruzione di SQL Server Agent in corso
{0}
Event LogApplication
CommentMom2008ID='{4E5D9C3C-3619-4FE3-AF9B-80782952FFAB}';MOM2008GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}

Member Modules:

ID Module Type TypeId RunAs 
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_ DataSource Microsoft.Windows.EventProvider Microsoft.SQLServer.SQLDefaultAccount
GenerateAlert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.SQLServer.2008.SQLServerAgent_initiating_self_termination_1_5_Rule" Target="SQL2008Core!Microsoft.SQLServer.2008.Agent" Enabled="true" ConfirmDelivery="true" Remotable="true" Comment="Mom2008ID='{4E5D9C3C-3619-4FE3-AF9B-80782952FFAB}';MOM2008GroupID={467ECC75-C5DA-42BD-955C-A73BBB51AF74}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F6DA1507_12AF_11D3_AB21_00A0C98620CE_" Comment="{F6DA1507-12AF-11D3-AB21-00A0C98620CE}" TypeID="Windows!Microsoft.Windows.EventProvider" RunAs="SQL!Microsoft.SQLServer.SQLDefaultAccount">

      <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>51</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.2008.SQLServerAgent_initiating_self_termination_1_5_Rule.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

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

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>