Automation with Scheduled Tasks

Batch Utility With Scheduler

The Batch Utility was created as a command line program so it can be easily invoked from within a batch file. The Windows Server Task Scheduler can then be used to run the batch file according to whatever schedule is desired.

An example of the contents of such as batch file is shown below.

Batchutility.exe TestFile1.csv https://1to1.iservicecrm.com/iservice.asmx agent4utility password -renameinput

Batchutility.exe TestFile2.csv https://1to1.iservicecrm.com/iservice.asmx agent4utility password -renameinput

This batch would process against two files, TestFile1 and TestFile2, located in the same directory as the batch file. The file can be located in any directory that is accessible from the location of the batch file.

Using the task scheduler and a batch file allows you to generate files using a reporting tool, such as SQL Server Reporting Services, and save those files into the directory specified by the batch file. The file will then be executed by the Windows Task Scheduler as required (daily, weekly, etc.) and the files will be automatically processed.

The optional -renameinput parameter will rename the file upon completion, thus allowing your report writing software to place a new file into the directory without a file naming conflict.

Batch Form Utility With Scheduler

The Batch Form Utility can also be run from within a batch file and scheduled for regular execution.  The syntax for the Batch Form submission is explained here.