sysdownloadlist System Table - SQL Server 2000

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_servernvarchar(30)Name 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. For Microsoft® SQL Server™ version 7.0, this value can be 1, which corresponds to JOB.
object_id1uniqueidentifierObject identification number.
target_servernvarchar(30)Name 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.