dbo.systargetservers (Transact-SQL)


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

Applies to: SQL Server (SQL Server 2008 through current version).
Column nameData typeDescription
server_idintServer ID.
server_namesysnameServer 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.

Community Additions