What database table is HPC job run information stored in ? RRS feed

  • Question

  • Hi all - my 1st post.

    I create a capacity report on our HPC Grid. To do this I use my own T-SQL against the jobs table in our CCPClusterService database. Recently there has been a change that has deleted data from this table and I am now lissing most of Spet data. I extract one complete month of data in order to do my monthly capacity report.

    What is confusing me is my user can run a report from the HPC Manager application that gives him the total jobs run for the whole of Sept. This historical job information must be in another table or view but looking through the CCPClusterService & CCPReporting databases I cannot work out which table this data is being extacrted from.

    Can anyone shed any light  ?

    Thanks in advance.

    Thursday, October 3, 2013 9:24 AM