Removes the specified server from the list of available target servers.
- [ @server_name = ] 'server'
The name of the server to remove as an available target server. server is nvarchar(30), with no default.
- [ @clear_downloadlist = ] clear_downloadlist
Specifies whether to clear the download list for the target server. clear_downloadlist is type bit, with a default of 1. When clear_downloadlist is 1, the procedure clears the download list for the server before deleting the server. When clear_downloadlist is 0, the download list is not cleared.
- [ @post_defection = ] post_defection
Specifies whether to post a defect instruction to the target server. post_defection is type bit, with a default of 1. When post_defection is 1, the procedure posts a defect instruction to the target server before deleting the server. When post_defection is 0, the procedure does not post a defect instruction to the target server.
The following example removes the server
LONDON1 from the available job servers.
USE msdb ; GO EXEC dbo.sp_delete_targetserver @server_name = N'LONDON1' ; GO