dbo.systargetservers (Transact-SQL)
Applies to: SQL Server
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_interval | int | Number of seconds to elapse before the target server polls the master server for new download instructions. |
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre