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

Workflow

Purpose

In the jdDatabaseStatement workflow an SQL command is executed from a first job. This command counts the total number of order history entries in the JS7 database for the current date. The second job implements a simple shell script which 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 steps described below:

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. In the Order History panel you can see if the order is successful and has 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 in the upper right-hand corner of the log view window.