Export (0) Print
Expand All

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 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft