Reading completed jobs
When a job has completed processing, the following columns are updated:
Column |
Type |
Value |
Description |
|---|---|---|---|
processed |
Integer |
1 |
Indicates processing status of the job. 1 = completed |
processedDate |
datetime |
processed time |
The time at which the job was processed |
severityCode |
Integer |
1 or 3 |
1 = successful, 3 = error during processing |
statusCode |
varchar |
6-digit number |
Status code "000000" for success, any other value means error |
statusMessage |
varchar |
Error message |
"Success" for success, otherwise a description of the error |
mimeType |
varchar |
Output type |
The mime type of the output, or null in case of error. (Technically this is the value of metadata "interformng.mimeType" at the end of the workflow) |
resultFile |
varchar |
Filename |
The output filename specified in the workflow, or null if none was set (typically only used in case of file system output). |
pdfData |
blob |
Output document |
The output document that was saved to the database using the "to database" component, or null if no output was saved to the database. |
The metadata rows for the job will also have been updated. Existing rows in the metadata table are updated with the value that the metadata key has at the end of the workflow. New rows are added for metadata keys that were generated during the workflow execution.
