ERP Scheduler: Setup and Configuration

Pre-Requisites

1.  Make sure you have login privileges to the SQL server and SQL. (Refer to the Client connection page for this information.)

Step-by-Step Guide

1. Installation: Scheduler is typically installed in C:\Program Files (x86)\Cultura\Scheduler
   
   
   
   
2. The ScheduleConnection XML file configures the Server and Database where ERP resides (Agrisoft).
   
   
   
   
3. In ERP database the ImportExportConnections table defines the Scheduler database (External).
   
   
4. In ERP database the Schedule table defines what jobs to run and when to run them.
   
   
   
   
5. Task Manger is used to start and stop the Scheduler
   
   
   1. Right Click Start Bar to access the Task Manager
      
      
      
   2. On the Services tab you will
      
      
      
   3. Services
      
      
      
   4. Scheduler Log is located on Local Disk where scheduler is installed (see above)
      
      
      
      
   5. Scheduler Log shows each step of a job as it is executed 
      
      
      
      
6. There are three tables in the External database used by the Scheduler (Agrisoft_Ext - see ImportExportConnections above).
   
   
   
   
   1. Jobs table (ImportExportJob) defines each job to be performed
      
      
      
   2. Steps table (ImportExportStep) defines the steps needed for each job
      
      
      
   3. Map table (ImportExportMap) is used to associate columns between two data sources (i.e. ERP and CFS)
      
      
      
7. Notes