Problem Summary: Recovery of the hvrstats scheduled job after loss or accidentally deleting from HVR hub and the repository tables remain intact
A client reported deleting their scheduled hvrstats job from their scheduler. A query connecting as their hub owner still shows the tables for this Oracle hub.
SQL> select table_name from dba_tables where owner = '<hub_owner>' and table_name like '%STAT%'; TABLE_NAME ---------------------- HVR_STATS HVR_STATS_STAGING
Recovering the hvrstats scheduled job is pretty easy. We use the hvrstats command with the options below.
$ hvrstats -Cj <hub_owner>/password
Additional information can be found at https://www.hvr-software.com/docs/commands/hvrstats