query
RESULTSET
query
  BATCHID BATCHTIME FILEFORMAT STATUS
CACHED false
EXECUTIONTIME 19
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 164
2 MFR
3 /mstrQueries/utilityQueries/DataImport/Operators/baseOperatorImport.cfm
struct
CACHED false
COLUMNLIST BATCHID,BATCHTIME
EXECUTIONTIME 14
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 164
2 MFR
3 $CRMOperatorsETL
4 /mstrcfmod/CRM/batch/crmOperatorsETL.cfm
Batch 17023799 Created to run @ {ts '2024-09-29 04:41:15'}
struct
CACHED false
COLUMNLIST BATCHID,BATCHTIME,FILEFORMAT,FILEPROCESSOR
EXECUTIONTIME 4
RECORDCOUNT 1
SQL select batchId, batchTime, fileFormat, fileProcessor from tbl_EAI_InboundBatches where ownerId = ? and ownerType = ? and batchId = ?
SQLPARAMETERS
array
1 164
2 MFR
3 17023799
17023799
query
RESULTSET
query
  BATCHID BATCHTIME FILEFORMAT FILEPROCESSOR
1 17023799 2024-09-29 04:41:15.907 $CRMOperatorsETL /mstrcfmod/CRM/batch/crmOperatorsETL.cfm
CACHED false
EXECUTIONTIME 4
SQL select batchId, batchTime, fileFormat, fileProcessor from tbl_EAI_InboundBatches where ownerId = ? and ownerType = ? and batchId = ?
SQLPARAMETERS
array
1 164
2 MFR
3 17023799