Destination database table. Contains the job ID of the last job (from a batch) that was successfully applied. (A job is a complete transaction from the transaction log of the publishing database.) Also, if present, contains the name of a job that has paused distribution while waiting for manual synchronization.
| Column | Datatype | Description |
|---|---|---|
| publisher | varchar(30) | The name of the publishing server associated with the job ID. |
| publisher_db | varchar(30) | The name of the published database. |
| job_id | int | The job ID of the last job (from a batch) that was successfully applied. |
| publication | varchar(30) | The source publication. |
| article | varchar(30) | The source article. |
| description | varchar(100) | A description provided by the distribution process. |
This table does not have any indexes.
| sp_replsync |