How to best analyze ESS Job Schedules?
SummaryHow to best analyze ESS Job Schedules?
We have a basic need which we are struggling to find an answer to:
How do we best analyze the jobs from ESS schedule?
Per our SR with Oracle, we cannot write a BIP SQL to extract the data from ESS tables because the NAMES of the jobs are not stored in the database. This means that the SQLs we can write are of no use to use because it does not contain the basic element NAME along with all the other relevent info.
We also cannot effectively use the ESS UI because the search functionality is very limited, including not allowing a large download of the ESS data. SQL would be much better.