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) |
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 |
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.
'
Comments (
)
Link to this page:
//www.vb-net.com/Sql/Sql/Ts_sys-d_04l0.htm
|