Import Financial Actual Job Running Longer, wondering if we can monitor the job through database or enable kind of tracing for monitoring purpose.
Please share any information / SQL for the same. Thanks.
Please find the query
TO_CHAR(jr.start_date, 'MM-DD-YYYY HH24:MI:SS AM Dy') start_time_app,
TO_CHAR(JR.END_DATE, 'MM-DD-YYYY HH24:MI:SS AM Dy') END_TIME_APP,
ROUND(JR.TOTAL_EXECUTION_TIME/1000/60, 3) EXEC_MINS
FROM Cmn_Sch_Job_Runs Jr,
WHERE J.id = JR.JOB_ID
AND JR.LAST_UPDATED_BY = CSU.id
AND JR.START_DATE > sysdate-3
--AND j.name LIKE '%Generate Inv%'
ORDER BY JR.START_DATE DESC
Replace the name of the job with what eve job you want to monitor.
Thanks Suman for the response. However I am looking SQLs or monitoring technique which show me data/records which are getting processed or yet to process by Import Financial Actual Job. Would like to understand whether this long running job is actually working on records or its hung some where in PROCESSING state. Thanks.
Have you checked this ?
Where can I find functions used by Import Financial Actuals job
Do you see any entries related to this job in the bg logs ?
The status code can give you the state, however if you want to see the number of records processing then you have to do a trace to see what all tables it updates and build a query. I don't have that query at this moment.
Retrieving data ...