Changes the properties of a Merge Agent job that runs at a Microsoft SQL Server 2005 or later version Distributor. This stored procedure is used to change properties when the Publisher runs on an instance of SQL Server 2000. This stored procedure is executed at the Distributor on the distribution database.
sp_MSchange_merge_agent_properties [ @publisher = ] 'publisher' , [ @publisher_db = ] 'publisher_db' , [ @publication = ] 'publication' , [ @subscriber = ] 'subscriber' , [ @subscriber_db = ] 'subscriber_db' , [ @property = ] 'property' , [ @value = ] 'value' ]
sp_MSchange_merge_agent_properties is used in merge replication.
When the Publisher runs on an instance of SQL Server 2005 or later version, you should use sp_changemergesubscription to change properties of a Merge Agent job that synchronizes a push subscription that runs at the Distributor.