Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



systargetservers System Table - SQL Server 2000

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 nameData typeDescription
server_idintServer ID.
server_namenvarchar(30)Server name.
locationnvarchar(200)Location of the specified target server.
time_zone_adjustmentintTime adjustment interval, in hours, from Greenwich mean time (GMT).
enlist_datedatetimeDate and time that the specified target server was enlisted.
last_poll_datedatetimeDate and time that the specified target server last polled the multiserver's sysdownloadlist system table for jobs to run.
statusintStatus of the target server: 1 = normal; 2 = re-sync pending; 4 = suspected offline.
local_time_at_last_polldatetimeDate and time the target server was last polled for job operations.
enlisted_by_nt_usernvarchar(100)Username of the person executing sp_msx_enlist on the target server.
poll_internalintNumber of seconds to elapse before the target server polls the master server for new download instructions.

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