MSsubscriber_jobs (distribution database only)

Distribution database table. Associates each subscriber with the command that subscriber needs to receive.

Column Datatype Description
job_id int The job ID.
publisher_id smallint The local server ID of the publishing server.
publisher_db varchar(30) The name of the published database.
subscriber_id smallint The subscriber ID.
subscriber_db varchar(30) The name of the database on the subscribing server.
command_id int The ID of the command.

Index

ucMSsubscriber_jobs clustered, unique on publisher_db, publisher_id, subscriber_db, subscriber_id, job_id, command_id

Referenced by Stored Procedures

sp_replcleanup sp_MSkill_job