Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Unanswered: Replication - distribution agents?

    When distribution is scheduled to run at specific times for specific user, but that user is not connected to the server. Distribution tries to find that subscription, the error comes back:

    The step was retried the requested number of times(10) without succeeding.

    Where/how can I change the requested number to try two or three times.

    My problem is that it takes 10-15 minutes for those re-trys and which sometimes causes overlap with the next subscription coming in.

  2. #2
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: Replication - distribution agents?

    Check sp_update_jobstep in BOL, look for @retry_attempts and @retry_interval
    The best way would be to use a PULL subscription at the subscriber instead of PUSH at the publisher.


    Originally posted by cruzin
    When distribution is scheduled to run at specific times for specific user, but that user is not connected to the server. Distribution tries to find that subscription, the error comes back:

    The step was retried the requested number of times(10) without succeeding.

    Where/how can I change the requested number to try two or three times.

    My problem is that it takes 10-15 minutes for those re-trys and which sometimes causes overlap with the next subscription coming in.
    Steve

  3. #3
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: Replication - distribution agents?

    You can also identify the job in Enterprise Manager (Management->SQL Server Agent-> Jobs) then find the step and change the retry attempts there.

    Originally posted by dbadelphes
    Check sp_update_jobstep in BOL, look for @retry_attempts and @retry_interval
    The best way would be to use a PULL subscription at the subscriber instead of PUSH at the publisher.
    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •