We are trying to automate a Job to Monitor the Process Engine Heart Beat. Could you please let us know the Significance of end_date column in BPM_RUN_PROCESS_ENGINES.
Is it required to check for the end_date while monitoring the Heart beat. We have come up with the below query for monitoring. Please suggest.
select INSTANCE_NAME , HEART_BEAT, To_Number(sysdate-heart_beat)*1440 as DIFF from BPM_RUN_PROCESS_ENGINES