Jasinski Technical Wiki

Navigation

	Home Page
	Index
	All Pages

Quick Search

Advanced Search »

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

PoweredBy

Discuss (0) History

sysdownloadlist System Table - SQL Server 2000

Print

RSS

Modified on Fri, May 01, 2009, 10:54 AM by Administrator Categorized as SQL Server System Tables

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.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.