Need a java that code check the below table details and get the id and name .
Table name: Run
I am using query to check whether any entry that is currently in waiting status should not be more than 10min
Run id Run name Start_date End_date Intiated_by status
45 Footjob 07-APR-15 07-APR-15 ramesh Runned
21 crcjob 27-JUL-16 27-JUL-16 suresh Runned
88 kuljob 28-JUL-16 28-JUL-16 kullal Runned
76 nanjob 28-JUL-16 28-JUL-16 jillu Runned
89 harjob 28-FEB-18 admin waiting
Current query : select Run id,24*60*(SYSDATE - START_DATE) time from Run where STATUS ='WAITING’ and (24*60*(SYSDATE - START_DATE))>10,
I need to get the id and name of entry which is in below condition.
Problem here is I want get different entry data for example
Footjob should not run more than 2hours which is in waiting status, kuljob should not run more than 30min which is in waiting status
Time differs for each entry