Skip to Content
0

How to find expiration date of reports in Public Folders in Business Objects

Nov 16, 2017 at 04:40 PM

79

avatar image

Hello All,

How to find expiration date of reports ( Webi and Crystal) in Public Folders in Business Objects. We are having many reports developed years back and those are getting failed due to expiration of end date when it is scheduled to run. So wanted to check if we can get the expiration date of all reports and analyze the end date of the report and modify it to future date so we dont get frequent failures.

Thanks,

Kavin

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

2 Answers

AMIT KUMAR
Nov 16, 2017 at 04:48 PM
0

You can find the report schedule exipre date in the Instance manager in CMC.Select the option to find out all recurring jobs and then you can check the schedule exipre date.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Amit. This works for the reports scheduled in BO itself.

But we instead use Autosys tool to run our reports based on the dependency of Reporting data completion. Is there any query we can retrive it from Query Builder.

0
Mohammed Ashraf
Nov 17, 2017 at 06:28 AM
0

Hi Raj,

Use the below sample query from query builder, this will retrieve schedule info such start time and end time and recurring type.

also you can use recurring type in where clause, that gives schedule info (start time and end time) of all the recurring instances.

SELECT SI_SCHEDULEINFO.SI_STARTTIME,SI_SCHEDULEINFO.SI_ENDTIME,SI_UISTATUS, SI_RECURRING FROM CI_INFOOBJECTS WHERE SI_INSTANCE=1 and <SI_KIND=report type>

Thanks

Ashraf

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Note that the appropriate condition would be "si_recurring = 1".

0