select rowId, ownerId, ownerType, fileProcessor, fileFormat, defaultBatchClass, fseProcessEmail, clientProcessEmail, coalesce( repeatTime, '5:00 AM' ) repeatTime, repeatOptions, notifications, 'false' okayToSchedule, 'false' scheduled
from tbl_EAI_inboundFileProcessors with (nolock)
where repeating = 'Y'
and allowUpload = 'N'
and fileFormat like '$%'
and rowId = Continue
select rowId, ownerId, ownerType, fileProcessor, fileFormat, defaultBatchClass, fseProcessEmail, clientProcessEmail, coalesce( repeatTime, '5:00 AM' ) repeatTime, repeatOptions, notifications, 'false' okayToSchedule, 'false' scheduled
from tbl_EAI_inboundFileProcessors with (nolock)
where repeating = 'Y'
and allowUpload = 'N'
and fileFormat like '$%'
and ownerId > 0
order by ownerType, ownerId
select batchId
from tbl_EAI_inboundBatches
where fileProcessor =
and fileFormat =
and ownerId =
and ownerType =
and batchTime =