Re: Distribution Agents

Sounds like you have inconsistent metadata. Can you see if there are bogus
entries in MSdistribution_agents in the distribution database.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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



"Wingman" <Wingman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C8532C6E-88B2-43D7-AB84-CA0459154DF4@xxxxxxxxxxxxxxxx
Thank for the idea. After I did what you suggested, the following is
what
happened.

1. The red circle X disappears from the icons on Replication Monitor and
all its subfolders in EM, which is good.

2. The line item in the Distribution Agents folder(Replication
Monitor\Agents) in EM that I tried to remove is still there with the red
circle X.

3. When I stop and start the SQL service, the deleted agent records in
tempdb reappear. As a result, all the red circle X reappears on
Replicatin
Monitor and all its subfolders.

Apparently the Msreplication_agent_status table in tempdb is getting
information from somewhere to re-populate the entries. Any more idea
where
they are?

Wingman

"gopal" wrote:

Look in Msreplication_agent_status in tempdb for the agent name and
delete it.

Gopal

"Wingman" wrote:

No, it doesn't show up there.

"Hilary Cotter" wrote:

Does it show up in msdistribution_agents in the distribution
database? If so
delete it.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business
intelligence.

This posting is my own and doesn't necessarily represent
RelevantNoise's
positions, strategies or opinions.

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



"Wingman" <Wingman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B7A1B56-96BF-4047-AF69-9EBE4E4C8172@xxxxxxxxxxxxxxxx
Hilary,

Thank for the quick response. Here is the strange part. When I
right
click
and select 'Agent Propertiies' of the in-question distruibution
agent, it
gave me an error with the job-id not found (error 14262: the
specified
@job_id doe not exist). This indicates that the job id doesn't
exist in
either sysjobs or sysjobsteps tables. I double checked and indeed
it is
not
in there. Any other idea on how to remove this orphane entry
from the
distribution agents folder listing?

"Hilary Cotter" wrote:

They are jobs inside msdb in the sysjobs, sysjobsteps tables. The
table
the
SQL DMO/EM reads for this info in msdistribution_agents in the
distribution
database.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business
intelligence.

This posting is my own and doesn't necessarily represent
RelevantNoise's
positions, strategies or opinions.

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



"Wingman" <Wingman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF0376F6-FFCE-4272-91BE-50D6D7965D6E@xxxxxxxxxxxxxxxx
We are usign SQL 2K with SP4 and using transactional replication
with
push
methodl. The distribution database is in the same SQL server as
the
Publisher database.

Here is my question. In EM console tree, Replication Monitor ->
gents ->
Distribbution agents, where are the entries inside the
distribution
agents
folder stored? The reason I asked is that we appear to have an
orphane
entry
in there but I don't know how it gets in there and don't know
how to
delete
it. This entry is causing a red X circle on the Replciation
Monitor
icon
and other related folders in the console tree.


Wingman








.

Relevant Pages

  • Re: Distribution Agents
    ... Does it show up in msdistribution_agents in the distribution database? ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ...
    (microsoft.public.sqlserver.replication)
  • Re: Distribution Agents
    ... Look in Msreplication_agent_status in tempdb for the agent name and delete it. ... "Hilary Cotter" wrote: ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot Agent account rights
    ... Its an alias for database owner; database users in this role can use this ... Hilary Cotter ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ...
    (microsoft.public.sqlserver.replication)
  • Re: Log Reader with An access violation occurred
    ... "Hilary Cotter" wrote: ... > Looking for a book on SQL Server replication? ... > database) but this is the first with 2003. ... >> eg set up Distribution as normal with all defaults ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_addarticle without re-creating entire new snapshot
    ... "Hilary Cotter" wrote: ... Director of Text Mining and Database Strategy ... Use Paul ...
    (microsoft.public.sqlserver.replication)