Hi Saurav, This is a little tricky to answer. I believe what you would need to do is look at JOB_STATUS table for a given experiment/process. There will be a SUBMITTED status, an ACTIVE status and then either a COMPLETED or FAILED or CANCELED status.
You would want to get the time different between the ACTIVE and the COMPLETED/FAILED/CANCELED status. This would give the elapsed time of the job. Then you would need to multiple this time, in hours, with the number of cpus used in the job (USER_CONFIGURATION_DATA.TOTAL_CPU_COUNT). Someone on the list might have a better idea, but I think that's the general gist of how you would get cpu hours used. Thanks, Marcus > On Aug 13, 2023, at 1:52 PM, saurav kumar jha <imsauravgaurav...@gmail.com> > wrote: > > Hi Community, > I have a question regarding this jira. > > 10. The total cpu-hours used 1. by a user, 2. sorted, 3. quarterly, 4. > plotted over a period of time > 11. The total cpu-hours consumed by application, sorted, quarterly, plotted > over a period of time > > These are the two requirements with respect to cpu hours. > > Although the COMPUTE_RESOURCE_SCHEDULING table has some of the information, I > couldn't find any table which stores cpu hours used information. > > Can anyone please tell me where I can get this info? > > Thanks & Regards, > Saurav Kumar Jha
smime.p7s
Description: S/MIME cryptographic signature
