Prev: Script to start replication agent
Next: using a UDF as a filter in trans replication
From: wadii boulila on 23 Feb 2010 14:48
I have performed a transactional replication in my company.
However, replication agents are idles. I need a script or a command sql to
start the three agents (snapshot, journal and distribution).
I write a script to create the transactional agent; however, these three
agents are idles and need to be started.
When I right click and I set start they work. However, I need to perform
this automatically with a script transact-sql or a command sql.

Tahnks a lot for your help.

url:http://www.ureader.com/gp/1156-1.aspx
From: I would like a replication that not ex on 5 Mar 2010 17:46
Thanks a lot finally it works!!!
Please how can I get the name of the replication agent. For example, when I
drop the replication and I recreate it, the name of replication agent
increments:
EXEC dbo.sp_start_job N'STANDARD-base-base-5' ;

So how can I get this name to let "sp_start_job" with a variable having as
value the name of the replication agent.

Thanks a lot for your help.

"Paul Ibison" wrote:

> sp_start_job is all you need. Or you could have schedules which run every
> minute. or you could have continuous schedules and a backup schedule to
> restart in the event of connection failures.
> HTH,
> Paul Ibison
>
From: Ben Thul on 8 Mar 2010 10:40
The tables you're looking for are at the distributor and match the
pattern '%agents'. I found 5 on mine: one each for snapshot,
distribution, merge, queue reader, and log reader. The contents of
these tables should be what you're looking for. Hope this helps.
--
Ben

On Mar 5, 4:46 pm, I would like a replication that not ex
<Iwouldlikeareplicationthatno...(a)discussions.microsoft.com> wrote:
> Thanks a lot finally it works!!!
> Please how can I get the name of the replication agent. For example, when I
> drop the replication and I recreate it, the name of replication agent
> increments:
> EXEC dbo.sp_start_job N'STANDARD-base-base-5' ;
>
> So how can I get this name to let "sp_start_job" with a variable having as
> value the name of the replication agent.
>
> Thanks a lot for your help.

From: I would like a replication that not ex on 8 Mar 2010 13:52
Thank you for your response.

I don't understand what command to execute to get the name of these agents?
Another question: It is possible to let the name of these agents constant?
Indeed, when I drop the replication and I recreate it, the names of
replication agents increments.

Thanks a lot

"Ben Thul" wrote:

> The tables you're looking for are at the distributor and match the
> pattern '%agents'. I found 5 on mine: one each for snapshot,
> distribution, merge, queue reader, and log reader. The contents of
> these tables should be what you're looking for. Hope this helps.
> --
> Ben
>
> On Mar 5, 4:46 pm, I would like a replication that not ex
> <Iwouldlikeareplicationthatno...(a)discussions.microsoft.com> wrote:
> > Thanks a lot finally it works!!!
> > Please how can I get the name of the replication agent. For example, when I
> > drop the replication and I recreate it, the name of replication agent
> > increments:
> > EXEC dbo.sp_start_job N'STANDARD-base-base-5' ;
> >
> > So how can I get this name to let "sp_start_job" with a variable having as
> > value the name of the replication agent.
> >
> > Thanks a lot for your help.
>
> .
>
 | 
Pages: 1
Prev: Script to start replication agent
Next: using a UDF as a filter in trans replication