Execution Log
The Executions page contains an interactive log of all executed and queued jobs in Yotilla. Jobs are listed separately for the Development and Production environments. The Executions page is a valuable tool for verifying and monitoring operations in Yotilla as well as for troubleshooting.
A job can consist of several job steps. Each job step executes a single SQL template, which can contain multiple SQL statements. The Executions page can be used to
- check the generated SQL statements
- check the duration of jobs, jobs steps and single SQL statements
- check the number of affected rows of jobs, job steps and single SQL statements
The Run Cycle ID is a unique identifier for every job step that has inserted or updated rows into the data warehouse database tables. Every database table that is generated by Yotilla has either one or two columns with a Run Cycle ID:
- IRID (Insert Run Cycle ID) = Run Cycle ID of the job step that has inserted the row
- URID (Update Run Cycle ID) = Run Cycle ID of the job step that has updated the row. The URID column is only present if updates have been performed on the table.
You can filter the jobs in the table by typing into the Search field (case insensitive), or search for a specific job step by its Run Cycle ID. To view all jobs, clear the Search field or refresh the page.
| Column | Description |
|---|---|
| Start | Time when the job started |
| End | Time when the job ended |
| Runtime | Total duration of the job |
| Label | Type of job. For more information, see Job Types |
| Scope | The affected source system, source, or business object |
| Affected Rows | Total number of affected rows of all steps in the job |
| Steps | Total number of job steps |
| Status (icon) | Green = success, red = error (hover cursor over icon to view error message) |
| Details | Click on the link to show details for the job steps. For more information, see Job Details |
