How do I determine the number of jobs currently executing and pending via AdminTools.
I can determine overall using si_schedule_status, but would like to obtain info for each of the job servers or each server group.
a) from the job server
FROM CI_SYSTEMOBJECTS WHERE si_name='CrystalReportsJobServer-1' and SI_KIND='Server' and SI_SERVER_KIND='jobserver'
b) job servers attached to a report server group.
FROM CI_SYSTEMOBJECTS WHERE si_name='CrystalReportsJobServerGROUP-1'' and SI_KIND='Server'?
something like this?