query
RESULTSET
query
  BATCHID BATCHTIME FILEFORMAT STATUS
CACHED false
EXECUTIONTIME 16
SQL select top 1 batchId, batchTime, fileFormat, status from tbl_EAI_InboundBatches with (nolock) where ownerId = ? and ownerType = ? and status = 'PENDING' and fileProcessor in ( ? ) order by batchTime desc
SQLPARAMETERS
array
1 387
2 BRO
3 /mstrQueries/utilityQueries/DataImport/Operators/baseOperatorImport.cfm
struct
CACHED false
COLUMNLIST BATCHID,BATCHTIME
EXECUTIONTIME 19
RECORDCOUNT 0
SQL select batchId, batchTime from tbl_EAI_InboundBatches where ownerId = ? and ownerType = ? and fileFormat = ? and fileProcessor = ? and batchClass = 'Z' and status ='PENDING' order by batchId
SQLPARAMETERS
array
1 387
2 BRO
3 $CRMOperatorsETL
4 /mstrcfmod/CRM/batch/crmOperatorsETL.cfm
Batch 17023798 Created to run @ {ts '2026-04-17 12:16:28'}
struct
CACHED false
COLUMNLIST BATCHID,BATCHTIME,FILEFORMAT,FILEPROCESSOR
EXECUTIONTIME 7
RECORDCOUNT 1
SQL select batchId, batchTime, fileFormat, fileProcessor from tbl_EAI_InboundBatches where ownerId = ? and ownerType = ? and batchId = ?
SQLPARAMETERS
array
1 387
2 BRO
3 17023798
17023798
query
RESULTSET
query
  BATCHID BATCHTIME FILEFORMAT FILEPROCESSOR
1 17023798 2026-04-17 12:16:28.523 $CRMOperatorsETL /mstrcfmod/CRM/batch/crmOperatorsETL.cfm
CACHED false
EXECUTIONTIME 7
SQL select batchId, batchTime, fileFormat, fileProcessor from tbl_EAI_InboundBatches where ownerId = ? and ownerType = ? and batchId = ?
SQLPARAMETERS
array
1 387
2 BRO
3 17023798