Replication Error of failure

• Shah_hs

  Ten Centuries

  Points: 1117

  More actions

  March 23, 2007 at 10:48 am

  #176887

  I am fed up of getting the below error message of repl. atleast once a day.

  JOB RUN: 'REPL:1001' was run on 3/23/2007 at 3:00:01 AM

  DURATION: 1 hours, 11 minutes, 11 seconds

  STATUS:  Failed

  MESSAGES: The job failed.  The Job was invoked by Schedule 421 (Replication agent    schedule.). The last step to run was step 3 (Detect nonlogged agent     shutdown.).

  Please see below for the description of my Replication Job:

  ------------------------------------

  Steps of Job:

  1. Distribution Agent startup message.

   db: distribution

   cmd:

   sp_MSadd_distribution_history @perfmon_increment = 0, @agent_id = 126, @runstatus =   1, @comments = 'Starting agent.'

  2. Run agent.

   cmd:

   -Subscriber [GIZMO] -SubscriberDB [TelehopBilling] -Publisher [ROGER] -Distributor   [ROGER] -DistributorSecurityMode 1 -PublisherDB [TelehopBilling]

  3. Detect nonlogged agent shutdown.

   db: distribution

   cmd:

   sp_MSdetect_nonlogged_shutdown @subsystem = 'Distribution', @agent_id = 126

  This Job is executed every hourly and an error is fired atleast once a day notifying failure of this process. Please help me in resolving this issue.

  Thanks,

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  March 26, 2007 at 7:02 pm

  #697031

  Is there any descriptive errors in the SQL Error Log?

  ---

  Kindest Regards,

• Shah_hs

  Ten Centuries

  Points: 1117

  More actions

  March 27, 2007 at 4:39 am

  #697089

  "Detect nonlogged agent shutdown" is the error.

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 27, 2007 at 11:10 pm

  #697316

  You may need to start logging the agent info to see what is causing...

   

  How to enable replication agents for logging to output files in SQL Server

  http://support.microsoft.com/kb/312292

   

  MohammedU
  Microsoft SQL Server MVP