...
Does the server state in the database mirror the actual state of the service?
- If the service is running but the database records it as being stopped, the service will not be served jobs.
| 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 |
...