I have a number of jobs that have gone into error. I want to be able to restart them, but they take a long time to run. Am I able to send them to a different batch queue of my choosing?
Apps9: Can i restart background jobs that error in a different batch queue?
This topic has been closed for comments
Userlevel 7
+18
If you're willing to be naughty, copy PROD to TEST, then do this in TEST first...
UPDATE transaction_sys_local_tab
SET queue_id = /* new_queue_id */,
state = 'Posted',
started = NULL,
executed = NULL,
error_text = NULL,
sid = NULL,
serial# = NULL
WHERE id IN (12345678, 12345679, 12345680);
Alternatively, go to Batch Queue Configuration, move those procedures to different queues, then create brand new jobs to duplicate the old ones. You can move a procedure by dragging it from one queue to another with the mouse.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.