Skip to Content

Schedule Report Duration

Hello,

We have lot of schedule reports run everyday in our deployment. Some of the report are running whole day and they finally get failed. As an Administrator , we want to get the list of reports which are running for longer duration. This way we can inform the business and work on fine tune of the reports queries. Can anyone suggest , how to get the schedule report duration list both success and failed.

Regards,

Shashi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 17, 2017 at 04:49 PM

    Hi,

    Use Query Builder to retrieve scheduled reports

    something like this:

    SELECT SI_NAME, SI_SCHEDULEINFO FROM CI_INFOOBJECTS

    WHERE SI_RUNNABLE_OBJECT = 1 AND SI_SCHEDULEINFO.SI_DEPENDENCIES.SI_TOTAL > 0

    and also try:

    SELECT SI_NAME, SI_LAST_RUN_TIME, SI_NEXTRUNTIME FROM CI_INFOOBJECTS WHERE SI_RECURRING = 1

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded