Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

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 nvarchar(30) Name of the source server.
operation_code tinyint Operation code for the job:

5 = STOP

object_type tinyint Object type code. For Microsoft® SQL Server™ version 7.0, this value can be 1, which corresponds to JOB.
object_id1 uniqueidentifier Object identification number.
target_server nvarchar(30) 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft