...
Servers should be activated, running, configured for queue processing and have non zero values for MaxQueueLength and MaxActiveJobs.
| Code Block |
|---|
select ServerID, convert(nvarchar(50), Hostname) as Hostname, ss.Name as ServerState, MaxQueueLength, MaxActiveJobs, IsQueueProcessingEnabled
from config.t_Server s
inner join config.t_ServerState ss on s.StateID = ss.ServerStateID |
...