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

systargetservers System Table - SQL Server 2000

Print

RSS

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

Records which target servers are currently enlisted in this multiserver operation domain.

Column name	Data type	Description
server_id	int	Server ID.
server_name	nvarchar(30)	Server name.
location	nvarchar(200)	Location of the specified target server.
time_zone_adjustment	int	Time adjustment interval, in hours, from Greenwich mean time (GMT).
enlist_date	datetime	Date and time that the specified target server was enlisted.
last_poll_date	datetime	Date and time that the specified target server last polled the multiserver's sysdownloadlist system table for jobs to run.
status	int	Status of the target server: 1 = normal; 2 = re-sync pending; 4 = suspected offline.
local_time_at_last_poll	datetime	Date and time the target server was last polled for job operations.
enlisted_by_nt_user	nvarchar(100)	Username of the person executing sp_msx_enlist on the target server.
poll_internal	int	Number of seconds to elapse before the target server polls the master server for new download instructions.

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