Distribution database table. Contains one entry for each command associated with a transaction in the MSjobs table. One transaction can contain many commands.
Column | Datatype | Description |
---|---|---|
publisher_id | smallint | The local server ID of the publishing server. |
publisher_db | varchar(30) | The name of the published database. |
job_id | int | The job ID. |
command_id | int | The command ID. |
art_id | int | The article ID. |
incomplete | bit | Indicates whether this is the full command, or if the command is broken into separate entries. |
command | varchar(255) | The actual command or command fragment. |
ucMSjob_commands clustered, unique on publisher_db, publisher_id, job_id, command_id
sp_replcleanup |