Overview
TaskMan (which is different from the Windows Task Manager) is a Windows service that:
- Polls the application database
- Executes SQL stored procedures
- Launches applications such as EDI, MRP, and APS
- Processes and generates reports (for more information about TaskMan specific to reports, see the Creating and Customizing Reports guide)
- Runs IDO methods
Polling the application database
TaskMan polls the application database to identify new tasks to run. It uses the polling interval defined on the Intranets form. On startup it connects to the application database.
When a task is found that is waiting to be run, the task information (including executable, type of task parameters, and user name) is queried and the appropriate processing is performed.
Executing SQL stored procedures
For a SQL stored procedure, the TaskMan launches a database process thread. The database process then connects to the application database. It logs in as the SyteLine user who submitted the task. The stored procedure is then executed using the process connection.
Launching applications
TaskMan launches a system process to execute any valid Windows application such as EDI (EDIImporter.EXE) and the SyteLine Scheduler (AIM_BATS.EXE), enabling the application to carry out its processing. The application is executed under the user account used by the TaskMan service.