ERP Scheduler: Setup and Configuration

Checking the ERP Scheduler, it's configuration and associated log.

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
   
   
   

   Open

   

   
   
   
   

2. The ScheduleConnection XML file configures the Server and Database where ERP resides (Agrisoft).
   
   
   

   Open

   

   
   
   
   

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 click Open Services to view scheduler
      
      

      
      
      
      

   3. Services allows you to Stop and Start the Scheduler
      
      

      
      
      
      

   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 (Job, Step and Map) in the External database used by the Scheduler (Agrisoft_Ext - see ImportExportConnections above).
   
   
   

   
   
   
   

   1. Jobs table (ImportExportJob) defines each job to be performed
      
      

      
      
      
      

   2. Step 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