Very Computer

by **Greg Livengo** » Fri, 10 May 2002 06:54:02

I started trying to figure out how to start and stop the replication
agent for my transactional publication. What I found that I could do
was the following to stop the agent

WHERE dest_db='myDB' AND artid='1'

This seems to work, but I wanted to get feedback on the following
questions

1. Is this an acceptable way to stop the transactional replication
agent?
2. How can I specify the subscription server along with the dest_db
in my select stmt?
3. Why is it that when I stop the first article all of the other
published articles stop their replication as well?
a. Note that I get an error indicating that the job is all ready
stopped if I try to stop the job for my other articles in the same
publication.

Thank you for your help in advance,
--Greg

by **Hilary Cotte** » Fri, 10 May 2002 10:28:51

this is only capturing the very last distribution_jobid in the
syssubscriptions table.

I normally query sysjobs for the job I am looking for using the description
field to locate the job I am looking for and then run sp_stopjob passing
this jobid

> I started trying to figure out how to start and stop the replication
> agent for my transactional publication. What I found that I could do
> was the following to stop the agent

> WHERE dest_db='myDB' AND artid='1'

> This seems to work, but I wanted to get feedback on the following
> questions

> 1. Is this an acceptable way to stop the transactional replication
> agent?
> 2. How can I specify the subscription server along with the dest_db
> in my select stmt?
> 3. Why is it that when I stop the first article all of the other
> published articles stop their replication as well?
> a. Note that I get an error indicating that the job is all ready
> stopped if I try to stop the job for my other articles in the same
> publication.

> Thank you for your help in advance,
> --Greg

by **George Li [M** » Fri, 10 May 2002 22:36:16

It is not recommended to query the system tables directly in this way.
Since the system tables may be modified in the future release.

If you do need to control the replication agents manually, we suggest you
use the replication ActiveX control. You can find detailed information
about how to use these controls in the SQL Server Books Online.

This posting is provided "AS IS" with no warranties, and confers no rights.

Best Regards,

George Li

Microsoft Support

Very Computer

How to start/stop replication agent for transactional replication via Transact SQL

How to start/stop replication agent for transactional replication via Transact SQL

How to start/stop replication agent for transactional replication via Transact SQL

How to start/stop replication agent for transactional replication via Transact SQL