Purpose of Query
This page provides the query to get the job its beginning date and end date.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
select * from <KB_name>.anajob
Query result example
650353;"My Source file based execution unit_18386";137651;810;-1;"2016-10-20 19:02:07.499";"2016-10-20 19:06:27.092"
140454;"My Package_15868";137997;810;-1;"2016-08-11 09:22:54.94";"2016-08-11 09:24:41.461"
142852;"My Package_15907";137997;810;-1;"2016-08-11 10:19:54.836";"2016-08-11 10:20:25.654"
Query result interpretation
This query will return the job names and their begin date and end date
Query for Oracle
Same as CSS
Query result example
Query result interpretation
Query for SQL server
Same as CSS
Query result example
Query result interpretation