Introduction

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 to access any database for which a JDBC Driver is available with the Agent.

Workflow

Purpose

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

Usage

To execute the workflow from the 10_DatabaseStatement folder follow the 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 the Order History panel you can see the order is successful and finished. 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 the upper right corner of the log view window.