Add JITL job template SetJobResourceJob

Feature

• For the handling of global variables that change values at a regular basis, for example a business date variable that is used by a larger number jobs, users would like to find a JITL job template to automate the task.
• Consider existing solutions for Shell scripts and PowerShell scripts using the JS7 REST Web Service API.
• Functionality
  • Create or update a job resource that holds a given variable.
  • Update the value of an argument and/or environment variable in the job resource.
    • For date values offer Java date format patterns to be specified from a parameter, for example dd/MM/yyyy,
  • Deploy the updated job resource.
•  Parameterization.
  • The job makes use of the following arguments:
    • controller_id (optional): The Controller ID to which the updated job resource will be deployed.
      • If this parameter is omitted then the default Controller will be used that is available from the JOC Cockpit user profile that is in place for the account that connects to JOC Cockpit.
    • job_resource (required): path to the Job Resource that should be created or updated. Both specification of a path and specification of the name work similarly.
    • key (required): name of the variable (case-sensitive)
    • value (required): value of the variable.
      • The value allows any strings, numbers etc.
      • A special syntax is supported for date values: [<java-date-pattern>], for example [dd/MM/yyyy]. The Java date pattern will by replaced by the job for the current date value. 
    • time_zone (optional): if a Java data pattern is specified for the value parameter then the date is calculated for the given time zone.
      • The time zone is specified from a string, for example "GMT", "Europe/London". Valid time zone strings as explained with https://en.wikipedia.org/wiki/List_of_tz_database_time_zones can be specified.
    • environment_variable (optional): name of an environment variable in the Job Resource that should automatically be populated with the value specified for the key. Technically the environment variable will hold a reference to the key.
• Operation
  • The JITL job connects to JOC Cockpit using user/password authentication and/or certificate based authentication.
  • The job makes use of authentication settings as explained with https://kb.sos-berlin.com/display/JS7/JS7+-+JITL+Common+Authentication

Patch

• A patch is available that provides this job for 2.4.1, 2.5.0 and 2.5.1
  • Please download the patch from https://download.sos-berlin.com/patches/patch_20230102_JITL-708_for2.4.1-2.51.jar
• In addition to the procedure for installing the patch that is explained with https://kb.sos-berlin.com/x/aaN2B, users should remove the documentation resource js7_job_documentation_v1.1.xsl in the Resources->Documentation view.
  • The resource is located in the sos/jitl-jobs folder .
  • After removing the resource JOC Cockpit has to be restarted.
  • If users omit this step then the SetJobResourceJob job still will work. However, users will not see the the job in list of JITL Jobs when using the wizard to configure the job.