sysdownloadlist

Transact-SQL Reference

Transact-SQL Reference

sysdownloadlist

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:

1 = INS (INSERT)
2 = UPD (UPDATE)
3 = DEL (DELETE)
4 = START
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.