Introduction

The JS7 - JITL SQLExecutor Job 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

In the workflow jdDatabaseStatement an SQL command is executed to count the total number of order history entries for the current date. The job contains a simple shell script that run the SQL command to get an Order history for the current date.

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

1. Click the folder 10_DatabaseStatement 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.