Hi all -
We have a real-time system for checking the status of lone workers, and I currently create a SQL Agent job for each worker, set to run according to when the next check time is due (what happens then is not relevant to this enquiry). We have been happily using this with 50 or so workers, but wish to scale up to a possible maximum of several thousand.
I started to get uneasy about creating that many jobs, but couldn't find any hard information about limits imposed on job creation. I did find that only 60 jobs can be started in any one minute, which may yet see this approach ruled out, but I wondered if anyone has any words of wisdom about having many, many jobs on a server.
Thanks for all comments,