SQL Queries - CAST Knowledge Base - Queries on jobs - How to get the Snapshot jobs starting and ending dates

Purpose of Query

This page provides the query to get the job its beginning date and end date.

 

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

 

Applicable RDBMS

RDBMSYes/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