Home
  •  

Replication: agent scheduled for retry.

Microsoft.SQLServer.2000.Replication__agent_scheduled_for_retry_ (Rule)

Knowledge Base article:

Causes

The specified replication agent has been scheduled to retry the requested operation. The process will retry until it reaches the configured maximum number of retry attempts for the job step.

Some of the situations where a retry is scheduled are:

Resolutions

If the retry message is infrequent, no user action is required.

Use sp_help_jobstep to view the current setting for the maximum number of times the "Run agent" step for the specified replication agent will retry. You can use the retry_attempts parameter of the sp_update_jobstep stored procedure to adjust the number of times a job step will retry.

If the retry message recurs frequently, troubleshoot the message that is causing the retry to be scheduled. Check the agent's history for messages that indicate why the retry had to be scheduled. In some cases you may need to enable more detailed logging for your replication agent.

External

For more information about configuring a log for replication, see the Microsoft Knowledge Base article 312292.

Element properties:

TargetMicrosoft.SQLServer.2000.DBEngine
CategoryEventCollection
EnabledFalse
Event Source$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$
Alert GenerateTrue
Alert SeverityInformation
Alert PriorityNormal
RemotableTrue
Alert Message
Replication: agent scheduled for retry.
{0}
Event LogApplication
CommentMom2005ID='{714A5BFA-67A5-4B85-8A1D-DC2E2E08B842}'

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.Replication__agent_scheduled_for_retry_" Target="SQL2000Core!Microsoft.SQLServer.2000.DBEngine" Enabled="false" Comment="Mom2005ID='{714A5BFA-67A5-4B85-8A1D-DC2E2E08B842}'" Remotable="true">

  <Category>EventCollection</Category>

  <DataSources>

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

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

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery>PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

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

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <RegExExpression>

              <ValueExpression>

                <XPathQuery>EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>MatchesMOM2005RegularExpression</Operator>

              <Pattern>^(17052|17055)$</Pattern>

            </RegExExpression>

          </Expression>

          <Expression>

            <RegExExpression>

              <ValueExpression>

                <XPathQuery>EventDescription</XPathQuery>

              </ValueExpression>

              <Operator>MatchesMOM2005BooleanRegularExpression</Operator>

              <Pattern>(^.*14152 and (not ^.*\n.*14152)) or (^.*14152.*\n.*14152)</Pattern>

            </RegExExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

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

      <Priority>1</Priority>

      <Severity>0</Severity>

      <AlertOwner>$Data/PublisherName$</AlertOwner>

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

      <AlertParameters>

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

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>