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?
Question
Apps9: Can i restart background jobs that error in a different batch queue?
This topic has been closed for replies.
+19If 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.
If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.