I have a monthly job which puts files into the queue and then works through them, and I’m currently uses Unique references, however they’re only unique per month, ie, one file will always be called Dashboard.xlsx. Obviously next month this file won’t be able to be added to the queue so I am looking for solutions and the ones I can think of are:
- Delete all transactions in the orchestrator queue to start from a clean slate (also if they want to rerun the job that month this would be useful)
- Adding a timestamp to the reference (which is the filename) to get it unique, however would this be fiddly to remove later on when working with the files?
- Remove the need for a unique reference, but unsure if this is opening a can of worms or not.
I can’t find a way for number 1 to work, as it only removes New Items, which these wouldn’t be, and 3 seems dodgy, so I assume I have to go with 2, but any pointers would be great please.