I am working on pulling out all the paused and recurring instances to an excel and rescheduling all the paused instances using sdk, as Iam new to it kindly could any one help me in getting it right as it would be very useful
As Iam not from java coding backdrop, it is slight difficult me to catch up
I have done similar things, but can’t share the code because it belongs to a client. However, there are a couple of ways you could approach this using the Java SDK.
Pull all of the paused reports into an IInfoObjects using a query like this:
Select SI_ID, SI_NAME, SI_SCHEDULING_INFO from CI_INFOOBJECTS where SI_SCHEDULE_STATUS = 8
Walk through the list to set the SI_NEXT_RUN to when you want it to run and set SI_SCHEDULE_STATUS to 9. If you want it to run right away, don’t set the next run date.
Save the updated IInfoObject.
If you think there will be more than 1000 paused reports, it might be better to “walk” the folder hierarchy using a recursive method (method that calls itself). But that can get complicated. Let me know if you need something like that.
Also, I usually export info from the CMS database to .csv files in my code instead of directly to Excel. These file will open in Excel so that you can manipulate them and they’re easier to output because they’re just text.