Set Batch Setting

The ExMeX Tool - Batch Setting is a Excel Sheet and a SQL Script for configure batch settings of a batch in the ExMeX Framework Core.

The batch setting feature is mainly used by the ExMeX Companion App (valid as of App version 0.4.0). However, it can also be used independently

Main features are setting the variables

  • IsActive
  • ExitOnError
  • MaxSqlCommandInChunk

How to configure Batch settings without the Companion App?

At least Version 2.13.0 of ExMeX Framework Core has to be installed. Please download first the current version of the…

At least Version 2.13.0 of ExMeX Framework Core has to be installed.

Please download first the current version of the Batch Setting Tool for the ExMeX Framework Core.

Backup ExMeX Framework Core

Before you update the batch settings in ExMeX Framework Core with the Set Batch Settings tool, you should create a backup of your ExMeX Framework Core database.

If you do not backup, well it’s up to you.

Installation

After downloading the latest version of the Set Batch Setting tool, please follow all the steps below to get the most out of the tool.

The installation of the Set Batch Settings tool has to be done only once!

  • Extract 7z-file to ./library/tool in your root directory.
  • A new folder will be added (if it not already exists): Set Batch Setting.
  • Copy or rename “./library/tool/Set Batch Setting/SetBatchSetting.orig.sql” file to “./library/tool/Set Batch Setting/SetBatchSetting.sql”.
  • Copy or rename “./library/tool/Set Batch Setting/Set Batch Setting.orig.xlsx” file to “./library/tool/Set Batch Setting/Set Batch Setting.xlsx”.

Configure batch settings

You can adapt and enhance the script as often as you like, as a Set Batch Setting only has to take place once. Reinstalling the metadata does not change the new configured and set values to a batch.

  • Open file “./library/tool/Set Batch Setting/Set Batch Setting.xlsx” to configure the batch settings as needed. Only add batch settings if you want to change anything. If not then skip the following steps.
  • Check the currently set values in the Metadata database:
    SELECT BatchLabel
          ,IsActive
          ,ExitOnError
          ,MaxSqlCommandInChunk
    FROM MetadataZoneCore.LoadBatchNowNow
    	
  • Add new rows to Excel “./library/tool/Set Batch Setting/Set Batch Setting.xlsx” with the batches where you want to change the installations.
  • Then copy the new content from the DML column into the script “./library/tool/Set Batch Setting/SetBatchSetting.sql” starting from line 50.
  • Open the “./library/tool/Set Batch Setting/SetBatchSetting.sql” file and run it in an SSMS. To be on the safe side, check the Messages tab for error messages!
  • Done. The new settings are applied to the batch(es). Check the new set values in the Metadata database:
    SELECT BatchLabel
          ,IsActive
          ,ExitOnError
          ,MaxSqlCommandInChunk
    FROM MetadataZoneCore.LoadBatchNowNow
    	

It is not necessary to install the metadata again. A Set Batch Setting is independent of the ExMeX Framework Core metadata.

Deployment

In case the settings for the "Set Batch Setting" should be deployed to other environments, such as development, test or production, please refer to the section Framework Core in Depth -> Extensions By User.

Posted 10 months agoby Dirk.Lerner