I am still getting use to these tables. just wanted to know if you are guys are aware where i can find the below coloumns
I want the start time, end time of the job and also trying to get the command which we are executing in the process tab of the job.
like startime,endtime, command.
Below is the query which you can use to get the content of the process tab
select * from ot where ot_oh_idnr in ( select oh_idnr from oh where oh_name='job_name')
SELECT soh.oh_name as SCHEDULE , jpp_object as OBJECT , jpp_erlststtime as STARTTIME , jppc_calekeyname as CALENDAR , DECODE (ot_type,0,'Process',1,'PreProcess',2,'PostProcess',ot_type) as TEXT_CONTEXT , ot_content as TEXTFROM oh soh INNER JOIN jpp ON soh.oh_idnr = jpp_oh_idnr INNER JOIN oh joh ON jpp_object = joh.oh_name and joh.oh_client = soh.oh_client LEFT OUTER JOIN ot ON ot_oh_idnr = joh.oh_idnr LEFT OUTER JOIN jppc ON jppc_jpp_lnr = jpp_lnr and jppc_oh_idnr = soh.oh_idnrWHERE soh.oh_otype = 'JSCH' AND joh.oh_client = 1000
Thanks Jessica, is there a way we can get the end time of the jobs which have already run?
for example, I need the startime and end time of a particular process