COLUMN SCHEDTAB FORMAT A15
COLUMN JOBNAME FORMAT A15
COLUMN APPLIC FORMAT A10
COLUMN CONDNAME FORMAT A30
COLUMN RO FORMAT A10
COLUMN DATE FORMAT A10
COLUMN OP FORMAT A5
COLUMN NODEGRP FORMAT A10
COLUMN NODEID FORMAT A10
select CMS_JOBDEF.SCHEDTAB, CMS_JOBDEF.JOBNAME, CMS_JOBDEF.APPLIC,
CMS_CON_J.CONDNAME, CMS_CON_J.ROWTYPE, CMS_CON_J.DATEREF, CMS_CON_J.OP,
CMS_JOBDEF.NODEGRP, CMS_JOBDEF.NODEID
from CMS_JOBDEF JOIN CMS_CON_J
ON (CMS_JOBDEF.JOBNO = CMS_CON_J.JOBNO)
Where CMS_CON_J.CONDNAME like '[NOM_DE_CONDITION]'
ORDER BY SCHEDTAB, JOBNAME, ROWTYPE ;
Recheche de jobs selon une quantitative ressource
COLUMN SCHEDTAB FORMAT A15
COLUMN JOBNAME FORMAT A15
COLUMN APPLIC FORMAT A10
COLUMN QRESNAME FORMAT A10
COLUMN NODEID FORMAT A10
select CMS_JOBDEF.SCHEDTAB, CMS_JOBDEF.JOBNAME, CMS_JOBDEF.APPLIC, CMS_QR_J.QRESNAME, CMS_JOBDEF.NODEID
from CMS_JOBDEF JOIN CMS_QR_J
ON (CMS_JOBDEF.JOBNO = CMS_QR_J.JOBNO)
Where CMS_QR_J.QRESNAME = '[RESSOURCE]'
ORDER BY NODEID, SCHEDTAB, JOBNAME;