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.

Community Additions

ADD
Show:
© 2014 Microsoft