Hi,

I have to generate a Job Run History report which should have Job End Time field. This field is not available in Job Run Statistics Report/Job Run History Report. This field can be displayed in Custom SQL Report. I was able to figure out the below query.

But I need to schedule this report and need the report for the previous run cycle. I need to add jobstream name, jobstatus, Scheduled Time and Job run duration fields in the report. What field OR value can be used to accomplish this?

Thank you in advance!!!

 SELECT  
Workstation_Name,
Job_Name,
Job_Run_Date_Time,
Job_End_Time
            
FROM
      MDL.JOB_HISTORY_V

WHERE

       Job_stream_name_in_run='SDLP_1XMT'  and
      JOB_RUN_DATE_TIME > '2024-09-20 08:00:00'

------------------------------
Prashant Ghode
------------------------------

Hi Prashant  ,

you can add this column JOB_STREAM_WKS_NAME_IN_RUN in the select 

SELECT  
Workstation_Name,

JOB_STREAM_WKS_NAME_IN_RUN,
Job_Name,
Job_Run_Date_Time,
Job_End_Time
            
FROM
      MDL.JOB_HISTORY_V

WHERE

       Job_stream_name_in_run='SDLP_1XMT'  and
      JOB_RUN_DATE_TIME > '2024-09-20 08:00:00'

regards 

Alessandro 

Thank you Alessandro. What should be used for jobstatus, Scheduled Time and Job run duration fields.

And I need to schedule this report and need the report for the previous run cycle, what to pass to JOB_RUN_DATE_TIME field?

Thanks.