Need to Stop Scheduling of 300 Reports

scheduling XI Scheduler
7

aniketp,

from this I assume you will be able to use joepeters’ code above, with a slight modification to it.

  1. obtain a list of the ID’s of the reports you would like to ‘PAUSE’ – you can use the utility found here to obtain these (column Report ID, use the Excel filters to narrow it down on the Documents Tab to the required reports)

  2. Change code to replace

si_recurring = 1

with

SI_ID IN ('51414','63048','63055','63056','63057','63058')

where ‘51414’,‘63048’,‘63055’,‘63056’,‘63057’,‘63058’ = the list you have obtained fron step 1) above. You may have to break this down into smaller chunks of say 50 instead of passing all 300 ID’s in one go.

and hey presto they should all have ‘PAUSED’

I have not tried nor tested this, so please enlighten us if it works.

Sushir Patel :uk: (BOB member since 2006-04-19)