in Administrators_Guide i’ve found this note:
The Any server option does not specify an order in which
servers are used to execute tasks. In other words, no
load balancing is performed. Instead, an instance of
the scheduler runs on each server connected to the
database. Periodically, each instance checks the database
in which information about scheduled jobs is stored.
The first scheduler instance to find a task that is due
to start runs it, then marks the task as complete in the
database where information about scheduled jobs is
stored. The scheduler instances running on the other
servers connected to the database then know not to run
the task. This behavior will not change if you install a
third-party load balancer.
Now there still some questions of understanding:
Question 1: We see on our 4-node cluster that all scheduled tasks (Any Server) run on same node. Can we change this behaviour?
Question 2: What happens if we set a lower “Scheduler Thread Throttle” and the limit will be reached. Will this node allocate the task? In this case we expect this situation: Next Run (sec) = 0 Status = Active This would be a stupid solution regarding all other nodes are bored.
Question 3: Would the situation change if we use a synch clock service in the cluster?