Migrate JobSchedulerExtractJob JITL Job (CSV)

Current Situation

• JS1 ships with the JITL job JobSchedulerExtractJob
• This job is not included with JS7

Desired Behavior

• Add the functionality of the job to the JS7 SQLExecutorJob
  • We do not want a separate job. Instead the functionality to extract result sets to .xml and .csv files is added to the existing job
• New job parameters include:
  • resultset_as_variables = "CSV" :
    • value is case insensitive.
    • value specifies that an output file in the respective CSV format should be created.
  • result_file = <file-path>:
    • The parameter specifies the path to the result file (CSV format).
    • This parameter is required if the parameter resultset_as_variables is used with a "CSV".
    • An absolute path or a path relative to the Agent's working directory can be specified.
    • CSV Format: variable length columns; comma separated; delimiter is a double-quote "; escaping of double-quotes is performed by \; numbers include a dot to specify decimals; no modification of the date's time zone and date format (DBMS default is used)

Next TODO

• resultset_as_variables = "XML"
  • XML Format: UTF-8 encoding; support for data types: number, string, date; numbers include a dot to specify decimals; no modification of the date's time zone; ISO date format is yyyy-mm-ddThh:MM:ss.

Maintainer Note

• This feature is intended for better compatibility of JS7 to previous branches.