Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, October 22, 2007 3:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, November 06, 2007 2:07 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 6:35 PM
Points: 222, Visits: 239

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 »

Add to briefcase

Permissions Expand / Collapse