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. |
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें