I do not see an HVR statistics job in my scheduler? Is it there?
There is but sometimes it may be hidden from view in the scheduler
(Re)-Enable seeing them by
To make the stats job visible choose the "Show" option under the view menu:
Additionally, if you need to (re)create the hvrstats job, run the following command in the hub (Hvrstats).
So, I first set my environment to my database ‘XE’ in my Windows environment with a Oracle hub database called "demo1_hub" and the hub database user "demo1_hub", it looks like the following:
hvrstats -Cj -h oracle -u demo1_hub demo1_hub/<user_password>
For -h <hub_database_type> the valid values are oracle, ingres, sqlserver, db2, db2i, postgresql, and teradata.
It's possible that the <hvr_hubdb_user_password> has to be given in an encrypted form. The easiest way to get this, is by initializing any channel in your HVR GUI, then copying it from the bottom left corner of the HVR Initialize window (don't include the apostrophe '):
Note for remote hub databases connection strings see