Introduction
Runs on a periodic basis (e.g. every one minute) to scan a SQL table to determine if a dispatch is required
How to Run JetTrac DBScanner
To run JTDBScanner, you will need these files in the same folder:
- JTDBScanner.exe
- ExitHandler.dll
Executable files and dll files should not be edited for any reason.
Default Functionality
Seamless integration between customer Dispatch system and JetTrac Field Service to kick off jobs with no user interaction required. Unlike most of JetTrac modules this program is not called from a Job Step of a job in the JMD. It is set up as a Windows service and runs continually on the service scanning a database for transactions to process.
JetTrac DBScanner Command Line
C:\DBScanner.exe C:\configuration.ini XMLFilePrefix C:\file.log
JetTrac DBScanner Configuration.ini
type is SQL or ACCESS
DbType=SQL
DbConnection=TestDbScanner@DGLENO\SQLEXPRESS
#DbType=ACCESS
#DbConnection=TestDbScanner.accdb
DbUsername=username
DbPassword=password
#SqlStatement=SELECT * FROM TestTable WHERE Processed=No;
SqlStatement=SELECT * FROM TestTable WHERE Processed=0;
RowTag=row
JobName=job
UpdateColumnName=WorkOrderNo
#UpdateTemplate=UPDATE TestTable SET Processed=Yes WHERE WorkOrderNo IN (#$$#);
UpdateTemplate=UPDATE TestTable SET Processed=1 WHERE WorkOrderNo IN (#$$#);
optional
#FieldMap=Id>xmlClientId|Name>xmlName