I got Distribution Agent failure

I got Distribution Agent failure
however everything working correctly, it's allways red x on distribution
agent.
I have transactional replecation between two virtual computer, i replecate
all tabels from my database, everything work correct however i got red X on
replication monitor, on distributer agene. Also i did'nt find any errors in
history of distributor agent.
When i change some rows on publisher and after this run agent i see the
changes?
Any ideas ?
Message posted via http://www.droptable.com
Please try running sp_MSload_replication_status.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul.
After running this procedure i got : The command(s) completed successfully.
and the return value is 0.
it doesn't print anything else.
Message posted via http://www.droptable.com
|||But does the red circle disappear when you refresh the replication agents?
Rgds,
Paul Ibison
|||O yeeeeeeeeeee. u r great.
However what happen wheb i was run this procedure, please explain.
Thanks. .
Message posted via http://www.droptable.com
|||The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and this procedure refreshes this
table. You might notice that a reboot also solves the issue - when you
restart the sql server service the msdb is recreated from the model database
so it has the same effect.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Sorry - meant the tempdb gets recreated, not the msdb...
paul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eVqGZyCaFHA.3712@.TK2MSFTNGP09.phx.gbl...
> The replication monitor gets its info from
> tempdb.dbo.MSreplication_agent_status and this procedure refreshes this
> table. You might notice that a reboot also solves the issue - when you
> restart the sql server service the msdb is recreated from the model
> database so it has the same effect.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>