Skip to Content
0

Recovering recurring schedule configurations.

Aug 04, 2017 at 11:41 AM

36

avatar image
Former Member

Hello Everyone,

We used to run recurring report schedules daily/weekly which is delivering to hundreds of users. Accidentally 3 recurring schedules got deleted and we don't have Audit enabled in the environment since it is used only for distribution.The issue here we need to reschedule the 3 recurring instances.Is there any way to get the recurring schedule configurations(like to which group its being delivered,format etc..)of the deleted recurring schedules.

Thanks in Advance,

Manhoj

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

3 Answers

AMIT KUMAR
Aug 04, 2017 at 12:14 PM
0

have you checked in the successful instance history.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 04, 2017 at 12:37 PM
0

Hi,

You need to have an instance in the history. Only then you can get the schedule configuration by clicking on the status - Success/Failed etc.
And what version of BO are you using? Just in case if you are on 4.2 you can check under CMC-> Recycle bin.

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

Thank you for your response.

The recurring schedules are distributing to multiple outlook groups containing hundreds of users.So the success instance corresponds to a particular user(each successful instance created for every member in the group) and we are not able to get the configured group those users belong to.

0
Manikandan Elumalai Aug 04, 2017 at 01:03 PM
0

Does the report itself got deleted or only the instance?

If it is only recurring instance, You can always get the schedule information from either success/failure instance from the history of the report?

If not you need to rely on your BIAR backup, email that is already distributed,etc..

Thanks

Mani

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Mani,

First of all Thanks you for all your blogs,it's has been very very helpful.

Only the recurring schedule got deleted.

From the Success/Failed instances in the history, only the details of the user(User's mail id) is available because that particular instance corresponds to that particular user only.But our requirement is to get the groups configured in that recurring instance for rescheduling back to original.

Thanks in advance,

Manhoj

0

For me, I will try to run the query to quickly get theedetail

SELECT SI_ID, SI_NAME, SI_SCHEDULEINFO.SI_DESTINATIONS FROM CI_INFOOBJECTS WHERE SI_RUNNABLE_OBJECT = 1 and SI_D = Report SI_ID

Alternatively you can also run this Scheduler utility from here.

http://www.forumtopics.com/busobj/viewtopic.php?t=231832


0