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%