Rouge Agents

How do I go about removing some rouge agents? Specifically, I have a
couple of snapshot agents for publications that do not exist. They
have the damn red 'X' on them and when I try to start the agent, I get
the error...'Error 14262: The specified @.job_id
('...bla...bla...bla...') does not exist.
TIA,
Larry...
do you mean rouge or rogue? Disconnect from EM, reconnect. Normally
this fixes this problem.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Hillary,
Thanks for the spell check.
My problem is that the subscriptions are gone, but the snap shot agents
are still there. Is there a table that I can go into and delete/remove
them? Will I need to delete any jobs any where?
Larry...
|||Larry,
It depends on where you are seeing them! Generally you see these "ghosted"
agents when entries get stuck in the agent_status table in Tempdb.
Restarting SQL SHOULD clear that up...
However, you could check the following:
distribution..ms*_agents
and tempdb..MS_replication_agent_status
Of course the obligatory disclaimer: Microsoft does not support, nor
encourage editing these system tables. Doing so may cause replication to
become damaged beyond repair. Do so at your own risk.
Donna Lambert
"LPR-3rd" wrote:

> Hillary,
> Thanks for the spell check.
> My problem is that the subscriptions are gone, but the snap shot agents
> are still there. Is there a table that I can go into and delete/remove
> them? Will I need to delete any jobs any where?
> Larry...
>