systargetservers (Transact-SQL)
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. |