Jobs Status

Job executions and statuses are stored in table TBTCO. The existing statuses are :

Status IDStatus
S Submitted
F Finished
A Aborted/Cancelled
P prepared ?

The following query lists the jobs called <JOBNAME> scheduled for the current day

SELECT jobname, jobcount, STATUS, SDLSTRTDT AS ScheduledDate, to_char(to_date(SDLSTRTTM,'HH24MISS'), 'HH24:MI:SS') AS ScheduledTime, strtdate AS StartDate, to_char(to_date( strttime,'HH24MISS'), 'HH24:MI:SS') AS StartTime, enddate AS EndDate, to_char(to_date(endtime,'HH24MISS'), 'HH24:MI:SS') AS EndTime, to_char(sysdate,'YYYYMMDD') AS CurrentDate, to_char(sysdate, 'HH24:MI:SS') AS CurrentTime FROM sappes.TBTCO WHERE SDLSTRTDT = to_char(sysdate,'YYYYMMDD') AND jobname='<JOBNAME>' ORDER BY strtdate DESC,strttime DESC 

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: October 24, 2018