sp_MSkill_job Replication Stored Procedure

Removes a single job from the distribution database while continuing to send all other data to the subscriber. Used on the distribution server.

Syntax

sp_MSkill_job job_id, publisher, publisher_db [, subscriber [, subscriber_db]]

where

job_id

Is the ID of the job being removed.

publisher

Is the name of the publication server where the job originated.

publisher_db

Is the name of the published database.

subscriber

Is the name of the subscription server.

subscriber_db

Is the name of the destination database.

Remarks

The sp_MSkill_job replication stored procedure is useful if all subscribers are failing on the distribution of a replicated transaction.

Important Use this procedure with caution. It is used on the distribution database.

Example

This example terminates job 90 that is waiting to be distributed.

sp_MSkill_job 90, WOLFHOUND, pubs

See Also