How to move Jobs which are set to Ready2EXE=True from one Job Queue to another Job Queue.

What version are you using?

What type of jobs do you want to move to a different queue?

What is the use-case for the move?

Hi Markus,

Version 8.0.1

thousands of LDP_Insert jobs are on one Queue dedicate for LDS target system. I have prepared another queue with the same role and Transfer half of the jobs from existing queue to the new queue to make it faster. I can increase the external threads on server one and increase MaxSessions but the servers resource is not that good go handle so many concurrent sessions.

Hi Markus,

Version 8.0.1

thousands of LDP_Insert jobs are on one Queue dedicate for LDS target system. I have prepared another queue with the same role and Transfer half of the jobs from existing queue to the new queue to make it faster. I can increase the external threads on server one and increase MaxSessions but the servers resource is not that good go handle so many concurrent sessions.

As a one-time event, you could change the property JobQueue.Queue to the 2nd queue. But ensure that you only do that for steps that haven't processed or loaded yet.

Hi Markus,

Does it work with version 8.1.4?
If I try from the ObjectBrowser tool with the following query: Update jobqueue set queue='\new_queue'  where ready2exe='true' , then I give this error: Database error 50000: Invalid changes of properties in jobqueue.

There is a trigger on dbo.JobQueue that is blocking you from doing this. (QBM_TUJobQueue) You would have to temporary disable this trigger to execute your statement (maybe do it in a single transaction or use emergency stop for DB Queue & Job Queue).

But I am not able to tell you which side impacts disabling this trigger could have.

Thank you very much!

The below will help, you can modify the number of queues you want to move at one and also put if jobs related to a specific process need to move.

exec QBM_PTriggerDisable 'JobQueue', 'QBM_TUJobqueue'
Update JobQueue set Queue = '\New_JobQueue'
where UID_Job in (
Select top 200 UID_Job from JobQueue with (nolock) where
JobChainName in ('ProcessName')
and
Ready2EXE = 'TRUE'
and Queue = '\Old_JobQueue'
)
exec QBM_PTriggerEnable'JobQueue', 'QBM_TUJobqueue'