dbo.sysdownloadlist (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Holds the queue of download instructions for all target servers.

Column nameData typeDescription
instance_idintIdentity column that provides the natural insertion sequence of rows.
source_serversysnameName of the source server.
operation_codetinyintOperation code for the job:

 1 = INS (INSERT)

 2 = UPD (UPDATE)

 3 = DEL (DELETE)

 4 = START

 5 = STOP
object_typetinyintObject type code.
object_id 1uniqueidentifierObject identification number.
target_serversysnameName of the target server.
error_messagenvarchar(1024)Error message if the target server encounters an error when processing the particular row.
date_posteddatetimeDate and time the job was posted to the target server.
date_downloadeddatetimeDate and time job was last downloaded.
statustinyintStatus of the job:

 0 = Not yet downloaded

 1 = Successfully downloaded
deleted_object_namesysnameName 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.

Community Additions

ADD
Show: