Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Replication : Distribution agent job

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-06 : 23:20:16
Gabe writes "I am using Transactional Replication and everything seems to be working fine. Data is sent across between PUBL and SUBS without problems, but one of the automated jobs that are created by SQL Server that start and stop the Replication agents is continuously executing, but has the FAIL status..

The job is is the "REPL-Distribution" which basically starts the Distribution agent....

I re-sync replication (re-initialize subscription) but it happens again.

Ths history of the job does not give me any details to why it fails...

Is this normal behavior ??

Pls advise

Thanks"
   

- Advertisement -