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
Release
Yes/No
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
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