SQL 2005 server Merge replication - no Merge properties or agent ??
Posted on 2007-03-26
I'm using SQL 2005 server SP2 on an SBS2003R2 server and SQL 2005 Express server on a Windos XP pro SP2 workstation. The SQL database is merge replicated on the XP workstation but I can't seem to gain access to the MergeAgent properties or find where to set a schedule (I want to replicate hourly).
When the merge, pull subcription was set up it only allowed 'on demand' synchronisation (no schedule could be established) I have read that one should be able to adjust the properties of the merge job but there is no "Job Folder' or server agents list displayed within the SQL Server Managment studio Express.
Can anyone tell me what I need to do to expose these properties, they must exist since I can synchronise through the synchronise application which is native to XP but this does not allow hourly scheduling.
I also notice that the sqlserveragent is not running at the subscriber. I would expect it to be running wouldn't I????
Hope someone can help???