MSjob_commands (distribution database only)

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.

Index

ucMSjob_commands clustered, unique on publisher_db, publisher_id, job_id, command_id

Referenced by Stored Procedures

sp_replcleanup