Using Advanced Queues to pass a payload to a Scheduled Job argument
I can use AQ to trigger the execution of a Scheduled Job, and I can use AQ to pass data to a stored procedure, but is there any way to do both at the same time? In other words, can AQ both trigger a job and pass the data payload on to that job as arguments for a Scheduler Program? I have searched the documentation and several blogs and forums and not found any answer. Must I therefore use two queues - one to trigger the job and the other to pass data to the procedure executed by the job?