Skip to Content
0
Former Member
Jul 05, 2010 at 01:26 AM

number of jobs on job server/group

23 Views

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?

TIA,

JM