ESP dSeries Workload Automation

 View Only
  • 1.  Historical data in DB

    Posted Oct 16, 2020 11:27 AM
    Is there a command to see how much amount of historical data in there in CA scheduler DB .


  • 2.  RE: Historical data in DB

    Broadcom Employee
    Posted Oct 18, 2020 10:58 PM
    Hi,

    There is no command from dSeries. You can use the sql statement -- select count(*) from the following tables

    ESP_APPLICATION
    ESP_GENERIC_JOB
    H_APPLICATION
    H_GENERIC_JOB.

    Hope it helps!
    Ravi Kiran


  • 3.  RE: Historical data in DB

    Posted Oct 20, 2020 12:55 PM
    Thanks Ravi .