Read completed jobs in database

Read completed jobs in database

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.

    • Related Articles

    • From database

      A workflow can be initiated by a job record in a database table. Only relational databases are supported. Please notice, that this input only supports the very specific table layout as described in the section, Database configuration, where in input ...
    • Database connections

      If you want InterFormNG2 to connect to a database in order to get input files for processing, then you need to configure the database as below. This section contains these topics: Prerequisite A prerequisite for a database connection is, that you ...
    • Adding new job records in a database

      New job records can be added to the database table by inserting rows in the "job" table. For new jobs, the following columns are used: Column Type Mandatory Value Description processed Integer Yes 0 Indicates processing status of the job. 0 = ...
    • To database

      This component writes the current workflow payload to a blob column in a database table. You have to specify the name of the database that the output should be saved to. The use of this is primarily intended for workflows that are initiated by the ...
    • Read from Windows share

      You can setup InterFormNG2 to read input files from a folder found via Windows share (Samba network/UNC). For that you need to create a workflow with the input type, Read from Windows share. This can e.g. be useful, if you want to monitor a folder on ...