RSXMB_TABLE_SWITCH is running to slow

[Former Member]

Hi All,

I am trying to run the RSXMB_TABLE_SWITCH job but it is only coping 100 messages at a time and it's causing my queues to build up.

I have got the setting MOVE_INSTEAD_OF_COPY but it still is only coping 100 messages at a time and i need to copy over 600000 messages.  Any help is welcome.

Regards,

CJ

[Former Member]

Problem resolved itself....

[Aleksandr]

Hello CJ.

How did you solve this problem?

[Former Member]

Hi Alexandr,

I just left the job to run and it eventually started to copy more than 100 messages at a time.