How to get a listing of jobs using a resource

grogahn · Post by **grogahn** » 30 Nov 2010 10:24

Is there a way to get a report listing all jobs that use a Control Resource?

philmalmaison · Post by **philmalmaison** » 01 Dec 2010 11:15

Hi,
Sure there is one...
select them in in DEF_LNKI_C Controlm/em table
for example:
select b.TABLE_ID,b.JOB_ID,b.RESOURCE_,a.JOBNAME,a.APPLICATION,a.GROUPNAME from DEF_LNKI_C b, DEF_JOB a
where
b.TABLE_ID = a.TABLE_ID
and
b.JOB_ID=a.JOB_ID
go (sybase)
; (oracle)

Regards,
Philmalmaison