Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

get status of running agent from the system at runtime Expand / Collapse
Posted Monday, October 22, 2007 3:57 AM


Group: General Forum Members
Last Login: Monday, March 2, 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
Posted Tuesday, November 6, 2007 2:07 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, December 7, 2015 4:27 PM
Points: 228, Visits: 268

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

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



Post #419308
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse