sql server replication: sp_MScheck_agent_instance -- sql server replication

sp_MScheck_agent_instance

Doug
10/27/2003 9:15:25 AM

sql server replication:

I'm doing some testing with the ActiveX Merge control
using VB 6.0.

I've been running through fine, Initializing, running, and
Terminating, the merge control.

I stepped through the code and after a Run and before a
Terminate, I stopped the job. I tried starting the job
again and am receiving a "Another merge agent for the
subscription(s) is running.". I'm assumming before I
didn't Terminate on the previous run.

I get a message "{call master..sp_MScheck_agent_instance
(N'23210013-E7C6-4944-BC58-7B4CB8BA3DAD', 4)}" The
2321.... is the subscription ID in the
sysmergesubscriptions table.

I just don't know now to get past this error, by
terminating the running agent or whatever other means are
necessary.

TIA for any help on this.

Doug

sp_MScheck_agent_instance

Hilary Cotter
10/27/2003 11:31:32 AM

bounce the sql server agent on your publisher.
[quoted text, click to view]

Re: sp_MScheck_agent_instance

Raymond Mak [MSFT]
10/27/2003 7:06:44 PM

Hi Doug,

You may also want to check that the merge agent for that particular
subscription has an on-demand schedule so you don't have the Merge ActiveX
control and the agent job accidentally running at the same time.

HTH

-Raymond

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.