...

The JS7 - JITL SQLExecutorJob is a JITL job template used to execute SQL statements and SQL procedures in a database. The job template can be used by an Agent to access any database for which a JDBC Driver is available with the Agentfor.

Workflow

Purpose

In the jdDatabaseStatement workflow  jdDatabaseStatement from a first job an SQL command is executed to count from a first job. This command counts the total number of order history entries from in the JS7 database for the current date. The second job implements a simple shell script that which returns the result of the fist job, i.e. the number of history entries.

...

To execute the workflow from the 10_DatabaseStatement folder follow the steps described below steps:

1. Click the 10_DatabaseStatement folder and expand the jdDatabaseStatement workflow.
   
   
   
   
2. Click the action menu of the workflow and use the Add Order menu item from the drop-down menu to add an order to the workflow.
   
   
   
   
3. Click the Add Order action menu item. A popup window will appear.
4. You can add the Order ID or leave the Order ID value empty, it will then use a default Order ID to process the order. Click the Submit button.
   
   
   
   
5. To check the status of the order click the Workflow name to make the Order History panel appear.
   
   
   
   
6. From In the Order History panel you can see if the order is successful and  hasfinished. Click the Order ID to open the execution log.
   
   
   
   
7. A log view window will open and the Order Log will be displayed. The Order Log contains log output from all jobs executed by the order. 
8. You can download the log file by clicking the Download button from in the upper right-hand corner of the log view window.
   
   

...