This a simple example, Example Config File DB Multi is more elaborate

CreateProcess.CommandLine="D:\txt2pdf\buckets\%DAT_001%.bat" "%DAT_002%" %DAT_003%
CreateProcess.CurrentDirectory=D:\txt2pdf\buckets
CreateProcess.Environment="spDAT_002=%DAT_002%", "spSTARTCOUNT=%startcount%", "spDateTime=%timestamp%"
CreateProcess.Priority=0
CreateProcess.MaxProcesses=5
CreateProcess.MaxQueueCount=15
Timer.Interval=10000
Timer.IntervalOnStart=100
Timer.WaitOnQueueFull=200
# change this logfile to reflect your preference
LogFile.FileName=D:\ihsStartPrg\StartProgDB.log
LogFile.Active=TRUE
LogFile.SizeLimit=200000
LogFile.AutoSave=FALSE
LogFile.Verbosity=1
DeleteAfterRun=TRUE
DeleteAfterRunAlways=FALSE
RetryFileOnFail=TRUE
OnlyProcessKnownVars=FALSE
Connectstring=Provider=SQLOLEDB;Server=SqlServr01;Database=DocStore;UID=meme;PWD=secret;
BaseSQL=Select top 1 Ident as Identifier from f04 where Exported=0
PreBaseSQL=Select top 1 * from VeryThoughView where Identifier=%Identifier%
QueueSQL=update F04 set QueNumber=%startcount%, QueDate=GetDate(), Exported=1 where Ident=%Identifier%
StartSQL=update F04 set StartDate=GetDate(), Exported=2 where Ident=%Identifier%
StopSQL=update F04 set EndDate=GetDate(), Result=%exitvalue%, Exported=3 where Ident=%Identifier%
ErrorSQL=update F04 set EndDate=GetDate(), Result=%exitvalue%, Exported=99 where Ident=%Identifier%



Gesponsorde koppelingen