Events
Sep 15, 6 AM - Sep 17, 3 PM
The best SQL community-led learning event. Sept 2025. Save €200 with code FABLEARN.
Get registeredNote
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Holds the queue of download instructions for all target servers.
| Column name | Data type | Description |
|---|---|---|
| instance_id | int | Identity column that provides the natural insertion sequence of rows. |
| source_server | sysname | Name of the source server. |
| operation_code | tinyint | Operation code for the job: 1 = INS (INSERT) 2 = UPD (UPDATE) 3 = DEL (DELETE) 4 = START 5 = STOP |
| object_type | tinyint | Object type code. |
| object_id 1 | uniqueidentifier | Object identification number. |
| target_server | sysname | Name of the target server. |
| error_message | nvarchar(1024) | Error message if the target server encounters an error when processing the particular row. |
| date_posted | datetime | Date and time the job was posted to the target server. |
| date_downloaded | datetime | Date and time job was last downloaded. |
| status | tinyint | Status of the job: 0 = Not yet downloaded 1 = Successfully downloaded |
| deleted_object_name | sysname | Name of deleted object. |
1 The object_id column can be a value of -1, which corresponds to a value of ALL if the operation_code column is a value of DELETE.