SQL Queries - CAST Knowledge Base - Queries on jobs - How to list KB jobs based on execution date

Purpose

This page provides the queries to list the KB jobs based on execution date.

Applicable in CAST Version

ReleaseYes/No
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅
7.2.x✅
7.0.x✅

Details

SELECT aj.idjob, 
       aj.jobnam, 
       aj.jobbegindate, 
       aj.jobenddate, 
       t.typnam 
FROM   anajob aj 
       JOIN typ t 
         ON t.idtyp = aj.jobtyp 
ORDER  BY aj.jobenddate;

Example of query result:

Notes / Comments

Related Pages