sql server replication: Merge Profiles? -- sql server replication

Merge Profiles?

confused
1/26/2007 2:26:02 AM

sql server replication: Hi,

Again thanks to Hilary and Paul for previous questions. My merge is up and
running now without any problems whatsoever....

I have two questions;

1. Where can I get a description of the different merge agent profiles and
what they do?.

2. Is it possible to get the merge agent to STAY logged in rather than
connecting every 10 minutes for replication. What I mean is that it takes
upto 10 minutes for the agent to log sometimes and therefore it would be
easier to get the agent to stay logged in. Is that possible?.

Many thanks

Re: Merge Profiles?

confused
1/26/2007 5:51:01 AM

Hi Paul,

Thanks for the info however i thing on the second question.

When I setup the merge, I configured it using the schedule of 10 minutes
between 8am and 6pm. When I go into the agent properties it does not give a
continous option!. Where would this option be?

Thanks
TIM

[quoted text, click to view]

Re: Merge Profiles?

Paul Ibison
1/26/2007 11:28:36 AM

You could use this page
http://msdn2.microsoft.com/en-us/library/ms151223.aspx to list the values
then http://msdn2.microsoft.com/en-us/library/ms147839.aspx to detail each
parameter.
For the second question, you could run the merge agent in continuous mode.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Re: Merge Profiles?

Paul Ibison
1/26/2007 2:26:08 PM

Continuous equates to "start automatically when sql server agent starts".
However you can't start continuous and stop it within a time boundary - at
least not easily. The simplest way to achieve this is to hacve a continuous
merge agent job which is disabled, and have another job which runs on a
schedule which enables the first job and starts is, then have a third job
which stops and disables the merge agent job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

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.