dbo-systargetservers-transact-sql.md

title	dbo.systargetservers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	dbo.systargetservers_TSQL dbo.systargetservers systargetservers_TSQL systargetservers
dev_langs	TSQL
helpviewer_keywords	systargetservers system table
ms.assetid	479d1314-be37-4d19-ac9c-419fc9110e53
author	stevestein
ms.author	sstein

dbo.systargetservers (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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

Column name	Data type	Description
server_id	int	Server ID.
server_name	sysname	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.