Automic Workload Automation

Expand all | Collapse all

DB Reporting tool

  • 1.  DB Reporting tool

    Posted 10-11-2017 09:35 AM
    Hi Everyone,

    Need a help with with DB reporting tool.
    I need a forecast report of a job for it's future executions of next 30 days.
    I made a query which I have attached in the issue. WHen I run the query it only gives me 2 results.
    could someone please help me with this.bqt3pqaw2snl.png14pfk9j6x3yh.pngj7a8ccin1cmu.pnghttps://us.v-cdn.net/5019921/uploads/editor/na/j7a8ccin1cmu.png" width="909">


    sungbu1edpqc.pnghttps://us.v-cdn.net/5019921/uploads/editor/v9/sungbu1edpqc.png" width="1326">

    TIA 
    Shani


  • 2.  DB Reporting tool

    Posted 10-11-2017 11:08 AM
    @Antoine Sauteron Please guide.


  • 3.  DB Reporting tool

    Posted 10-11-2017 11:21 AM
    The report of forecast data is restricted by how much forecast data has been generated.  If your datacenter only generates 2 days of forecast data, then this is all that you can report.

    Take a look at what AUTO_FORECAST_DAYS has been set to in variable UC_CLIENT_SETTINGS.

    Warning: If you increase this value, it will increase system overhead every time the forecast data is re-generated!