EIS Execution Summary
Description
- Categories
- EIS
EIS eXpress usage by report and month: one row per EIS report and calendar month of the run start, counting runs from eXpress and XL Connect. Email distribution jobs are deliveries of a run and are not counted.
A run counts as scheduled when it started more than a day after the logon of its EIS session, because scheduled runs keep the session of the user who created the schedule. Errors are runs with status Error or Terminated.
Executed within Days counts back from now, so the first month is partial. EIS purges its run history; EIS Execution History shows the earliest retained run.
A run counts as scheduled when it started more than a day after the logon of its EIS session, because scheduled runs keep the session of the user who created the schedule. Errors are runs with status Error or Terminated.
Executed within Days counts back from now, so the first month is partial. EIS purges its run history; EIS Execution History shows the earliest retained run.
SQL 36 lines
select /*+ no_index(erp eis_rs_processes_idx3 eis_rs_processes_idx4) */ err.report_name, err.report_id "EIS Report ID", era.application_name application, errc.category_name category, to_char(erp.start_time,'yyyy-mm') month, count(*) runs, count(case when erp.start_time-ers.logon_time>1 then 1 end) scheduled_runs, count(*)-count(case when erp.start_time-ers.logon_time>1 then 1 end) ad_hoc_runs, count(case when erp.submission_source='XL Connect' then 1 end) "XL Connect Runs", count(distinct erp.created_by) users, count(case when erp.status in ('E','T') then 1 end) errors, round(avg((erp.end_time-erp.start_time)*86400)) average_seconds, round(avg(erp.rows_retrieved)) average_rows from xxeis.eis_rs_processes erp, xxeis.eis_rs_sessions ers, xxeis.eis_rs_reports err, xxeis.eis_rs_applications era, xxeis.eis_rs_report_categories errc where 1=1 and erp.submission_source in ('eXpress','XL Connect') and erp.session_id=ers.session_id and erp.report_id=err.report_id and err.application_id=era.application_id and err.category_id=errc.category_id group by err.report_name, err.report_id, era.application_name, errc.category_name, to_char(erp.start_time,'yyyy-mm') order by err.report_name, month |
Parameters 7
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Application | LOV |
| |
| Category | LOV |
| |
| Report Name | LOV |
| |
| Seeded | LOV Oracle |
| |
| Executed within Days | Number |
| |
| User | LOV |
| |
| Responsibility | LOV |
|