BusinessObjects Board

Remove Old Recurring Schedules

scheduling XI Scheduler
#1

I’ve identified several hundred recurring schedules that are no longer needed and need to be deleted. I have their system ID and CUID. However, neither of these are available for filtering in CMC Instance Manager.

Is there a way to quickly remove a long list of recurring schedules based on ID?

BI 4.1

THANKS!!

jdean1012 :us: (BOB member since 2007-06-26)

#2

Nothing the CMC that would allow you to enter a batch of IDs and then delete the associated objects.

You could run a query in Query Builder to get the names of the instances, you could then manually go through the list in Instance Manager by name.

If you want to go the SDK route, it would be a pretty simple script. Something like:

IInfoObjects doomed = oInfoStore.query("select si_id from ci_infoobjects where si_id in (x,y,z...)");
for(Object o : doomed)
    ((IInfoObject)o).deleteNow();

joepeters :us: (BOB member since 2002-08-29)