Running auxiliary functions periodically

These functions should be run occasionally or periodically to keep the size of the database to a minimum and to have valid and correct data.

To run a batch job with no auto jobs, you must shut down the subsystem for auto start jobs and then start CMNGJOB. See instructions in Auto Start Jobs and Subsystems.

• 'Attribute. Calculate Search Sequence' (ATS995)

  This function should be run periodically.

  Note: The attribute functionality does not depend on if this function is used. It does, however, affect the performance of allocation and stock searches if you have many attributes with several valid values per attribute.

  The function calculates the search sequence in the order attribute file in this sequence:

  1. Counting the number of different attribute values per item and attribute identity in the stock.

     Once completed, the values are turned into negative and are placed in the search sequence field.

  2. Using this calculation, the search starts to validate the attribute where the most different values exist.

     If you start to validate the attribute, the result will be the least possible number of balance identities.

• 'Attribute. Delete Not Used' (ATS990)

  This function should be run occasionally or periodically to keep the size of the database to a minimum.

  The function performs a cleanup of the database with these activities:

  • Deleting attribute searches

    Attribute searches in, for example, 'Balance Identity. Display' (MMS060) and 'Balance Identity. Open Toolbox' (MWS068), creates a record attribute with a negative number. These are normally not deleted when the user exits the function and therefore remain in the database. This is done for performance reasons.

    If the check box 'Temp attrib no' is selected, the temporary attributes are deleted.

  • Deleting not connected attribute records

    To do this, the function scans through the attribute files and confirms that each attribute number has a corresponding order. Normally, these records are deleted when an order is deleted, but if the user session is interrupted for any reason, these records remain in the database.

    If the check box 'Orphn attrib no' is selected, the orphaned attributes are deleted.

  Note: When this function is run, the attribute records found are deleted - not archived.
• 'Macro Orders. Delete Not Used' (PMS992)

  This function starts 'Macro Orders. Delete Not Used' (PMS992).

• 'Product. Re-create Lowest Levels' (PDS910)

  This function should be run periodically when there are many changes in the product structure.

  Note: 

  • No other user in the system.
  • No auto start job activated for the component.
  • Max 1 active job allowed for the job queue.