Changes the properties of a Distribution 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_distribution_agent_properties [ @publisher = ] 'publisher' , [ @publisher_db = ] 'publisher_db' , [ @publication = ] 'publication' , [ @subscriber = ] 'subscriber' , [ @subscriber_db = ] 'subscriber_db' , [ @property = ] 'property' , [ @value = ] 'value' ]
sp_MSchange_distribution_agent_properties is used in snapshot replication and transactional replication.
When the Publisher runs on an instance of SQL Server 2005 or later version, you should use sp_changesubscription to change properties of a Merge Agent job that synchronizes a push subscription that runs at the Distributor.