CN_PROCESS_BATCHES_ALL WHILE CN_TRX_INTERFACE is running
Hi,
I would like to understand if CN_PROCESS_BATCHES_ALL is correctly populated (at the moment 7 BATCH_RUNNERS are running).
Running the following query I can see that there are several records related to the same salesrep_id but different request_id.
Could you please let me know if this is the right behaviour?
Regards
Manuela
ELECT *
FROM CN_PROCESS_BATCHES_ALL
WHERE PROCESS_BATCH_TYPE = 'CREATED_BY_LOADER'
AND STATUS_CODE ='IN_USE'
AND SALESREP_ID = 100000915
81,298021,1,2012007,100000915,457,55034,IN_USE,1,null,null,null,null,CREATED_BY_LOADER,1150,21/02/2013 2.38.04 ,295317,21/02/2013 2.38.26 ,1150,613424,39973,283,21/02/2013 2.38.26 ,01/07/2012,31/07/2012,null,2012007,null,null
81,650744,1,2013004,100000915,1205,161716,IN_USE,1228,null,null,null,null,CREATED_BY_LOADER,1110,02/10/2013 1.31.07 ,780545,02/10/2013 1.36.43 ,1110,1045547,39973,283,02/10/2013 1.36.43 ,01/04/2013,30/04/2013,null,2013004,null,null
I would like to understand if CN_PROCESS_BATCHES_ALL is correctly populated (at the moment 7 BATCH_RUNNERS are running).
Running the following query I can see that there are several records related to the same salesrep_id but different request_id.
Could you please let me know if this is the right behaviour?
Regards
Manuela
ELECT *
FROM CN_PROCESS_BATCHES_ALL
WHERE PROCESS_BATCH_TYPE = 'CREATED_BY_LOADER'
AND STATUS_CODE ='IN_USE'
AND SALESREP_ID = 100000915
81,298021,1,2012007,100000915,457,55034,IN_USE,1,null,null,null,null,CREATED_BY_LOADER,1150,21/02/2013 2.38.04 ,295317,21/02/2013 2.38.26 ,1150,613424,39973,283,21/02/2013 2.38.26 ,01/07/2012,31/07/2012,null,2012007,null,null
81,650744,1,2013004,100000915,1205,161716,IN_USE,1228,null,null,null,null,CREATED_BY_LOADER,1110,02/10/2013 1.31.07 ,780545,02/10/2013 1.36.43 ,1110,1045547,39973,283,02/10/2013 1.36.43 ,01/04/2013,30/04/2013,null,2013004,null,null
0