Recovering recurring schedule configurations.

[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

[Former Member]

Hi Mani,

First of all a very big Thanks for all your blogs.It'svery very helpful.

Only the recurring instance got deleted.

In the Success/Failed instances, we are able to get only the user name from the group for which the instance ran and not the original groups for which it is configured.

Thanks in advance,

Manhoj

[former_member182521]

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

[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

[former_member182521]

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

[Abhilasha]

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.

[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.

[amitrathi239]

have you checked in the successful instance history.