System Reporter 2.83PAR System Reporter User’s Guide
10.3.6 The scheduled_report_log Table
The scheduled_report_log_1 table is used to keep track of when each scheduled report has run.
Table
Column | Type | Comment |
|
|
|
rpt_id | INTEGER PRIMARY | A unique identifier for each scheduled |
| KEY | report. |
| (AUTO_INCREMENT) |
|
|
|
|
rpt_run_start_time | VARCHAR(64) NOT | The time the report was started. |
| NULL |
|
|
|
|
rpt_run_end_time | VARCHAR(64) NOT | The time the report finished |
| NULL | executing. |
|
|
|
rpt_run_hr | INTEGER | The hour that the report ran. |
|
|
|
rpt_run_status | INTEGER | The status for the report. |
|
|
|
10.3.7 The adprovconfig Table
The adprovconfig_1 table has a row for each adaptive optimization configuration.
Table
Column | Type | Comment |
|
|
|
adprovid | INTEGER PRIMARY | A unique identifier for each adaptive |
| KEY | optimization configuration. |
| (AUTO_INCREMENT) |
|
|
|
|
sysname | VARCHAR(32) NOT | The InServ system name. |
| NULL |
|
|
|
|
Administrative Tables | 10.9 |