A Way to Pause Integration Broker via Batch Job
Every evening we manually start the USER_PROFILE queue and every morning the queue is manually paused to prevent data conflicts. Is there a way to put this into a script that can be run from the server?
I wrote an AE program that just runs a SQL update. Example: Update PSQUEUEDEFN set QUEUESTATUS = 2 where QUEUENAME = 'USER_PROFILE
The value in the database changes but the queue doesn't really pause or start. Oracle has recommended that I clear the app server cache after the process completes which seems a bit extreme. I've run a trace and there is nothing within the trace indicating that pausing/starting the queue via the UI clears app server cache.