• Recherche de jobs selon une condition
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;
  • Recherche de jobs selon un calendrier
COLUMN APPLIC FORMAT A10
COLUMN DATEMEM FORMAT A10
COLUMN APPLGROUP FORMAT A10
COLUMN JOBNAME FORMAT A15
COLUMN MEMNAME FORMAT A30

select CMS_JOBDEF.APPLIC, CMS_JOBDEF.DATEMEM, CMS_JOBDEF.APPLGROUP, CMS_JOBDEF.JOBNAME, CMS_JOBDEF.MEMNAME
from  CMS_JOBDEF JOIN CMS_DATEMM
ON (CMS_JOBDEF.DATEMEM = CMS_DATEMM.CALNAME) 
Where CMS_DATEMM.CALNAME like '%[NOM_CALENDRIER]%' and CMS_DATEMM.JOBYEAR='2013'
ORDER BY MEMNAME;
  • Recherche de jobs selon nom de job
column APPLICATION format A15
column GROUP_NAME format A20
column JOB_NAME format A20

select APPLICATION, GROUP_NAME, JOB_NAME from DEF_JOB where JOB_NAME like '[CRIT]';
select count(*) AS [CRIT] from DEF_JOB where JOB_NAME like '[CRIT]';