March 23, 2007 at 10:48 am
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,
March 26, 2007 at 7:02 pm
March 27, 2007 at 4:39 am
"Detect nonlogged agent shutdown" is the error.
March 27, 2007 at 11:10 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply