Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

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

Column name Data type Description
server_id int Server ID.
server_name nvarchar(30) Server name.
location nvarchar(200) Location of the specified target server.
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

datetime Date and time the target server was last polled for job operations.
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
© 2015 Microsoft