Saturday, September 18, 2010

How to retrieve Summary of concurrent Jobs/status/Count in Last 1 hour

How to retrieve Summary of concurrent Jobs/status/Count in Last 1 hour?
Use following query:

selectfcpt.USER_CONCURRENT_PROGRAM_NAME,DECODE(fcr.phase_code,‘C’, ‘Completed’,‘I’, ‘Inactive’,‘P’, ‘Pending’,‘R’, ‘Running’,fcr.phase_code) PHASE ,DECODE(fcr.status_code,‘A’, ‘Waiting’,‘B’, ‘Resuming’,‘C’, ‘Normal’,‘D’, ‘Cancelled’,‘E’, ‘Errored’,‘F’, ‘Scheduled’,‘G’, ‘Warning’,‘H’, ‘On Hold’,‘I’, ‘Normal’,‘M’, ‘No Manager’,‘Q’, ‘Standby’,‘R’, ‘Normal’,‘S’, ‘Suspended’,‘T’, ‘Terminating’,‘U’, ‘Disabled’,‘W’, ‘Paused’,‘X’, ‘Terminated’,‘Z’, ‘Waiting’,fcr.status_code) STATUS,count(*)from apps.fnd_concurrent_programs_tl fcpt,apps.FND_CONCURRENT_REQUESTs fcrwhere fcpt.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_IDand fcpt.language = USERENV(’Lang’)and fcr.ACTUAL_START_DATE > sysdate – 1/24group by fcpt.USER_CONCURRENT_PROGRAM_NAME,fcr.phase_code,fcr.status_code

No comments:

Post a Comment