I'm trying to run jobs on a timer when the jobs are on a cluster and I don't know which server the job is assigned to.
It's essentially a problem of distributed timers and distributed transactions.
(If anyone has any resources on how similar problems have been solved in the past, I'd appreciate it.)