get status of running agent from the system at runtime

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » get status of running agent from the system...

get status of running agent from the system at runtime

Rate Topic

Display Mode

Topic Options

Author

Message

sagar-506255

Posted Monday, October 22, 2007 3:57 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, March 02, 2009 5:52 AM
Points: 17, Visits: 49

hi friends,
i hv implemented the sql 2005 merge replication functionality that is done from management studio in windows application using .net 2.0 and C#.

i m able to setup the replication and run the agents (snapshot and merge agents) sucessfully using the sql system based stored procedures.

now my difficulty is when i run the agents i hv to always check their status through management studio. therefore i m not able to show this status in my application to the user.

i tried for other stored procedures but i don't get the value at runtime.

so if anyone knows a better solution plz let me know asap.

Post #413335

Chris Becker

Posted Tuesday, November 06, 2007 2:07 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, February 22, 2013 11:49 AM
Points: 220, Visits: 216

Good. YOu are a c# programmer - take advantage of RMO

Lookup "Programming with Replication Management Objects" in books online.

Enjoy.

ChrisB MCDBA
MSSQLConsulting.com

Post #419308

« Prev Topic | Next Topic »

Permissions