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.
------------------------------
Prashant Ghode
------------------------------
Original Message:
Sent: Fri October 11, 2024 09:14 AM
From: Alessandro Tomasi
Subject: Custom Sql Report
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
------------------------------
Alessandro Tomasi
Original Message:
Sent: Wed October 09, 2024 04:56 AM
From: Prashant Ghode
Subject: Custom Sql Report
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
------------------------------