Skip to main content

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?

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.