Recovery the hvrstats scheduled job after loss or accidentally deleting from HVR hub and the repository tables remain intact.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #22425

    Donna Zehl
    Keymaster

     

    Knowledge Base

    Recovery the hvrstats scheduled job after loss or accidentally deleting from HVR hub and the repository tables remain intact.

    .

    Problem Summary:

    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

     

    Description

    Recovering the hvrstats scheduled job is pretty easy. We use the hvrstats command with the options below.

     

    Answer

       $ hvrstats -Cj <hub_owner>/password

    Additional information can be found at

              https://www.hvr-software.com/docs/commands/hvrstats
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.

© 2019 HVR

Live demo Contact us