Skip to Content
0

Schedule Report Duration

Feb 16, 2017 at 04:38 PM

64

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Feb 17, 2017 at 04:49 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded