Enable run types for scheduled job child tables

  • Freigeben Version: Australia
  • Aktualisiert 12. März 2026
  • 1 Minute Lesedauer

    • The run types; Day and Month in Year, Day in Week in Month in Year, and Week in Month, require the fields; Day, Month, and Year to be visible. Child tables which don’t display those fields can't create jobs with that run type selected.

    Vorbereitungen

    Identify the child table for which you’re configuring new run times. To find child tables, follow the instructions in Find child tables for scheduled jobs.

    Role required: admin

    Prozedur

    Configure Run time options:
    1. Navigate to All > System Definition > Scheduled Jobs.
    2. Select New.
    3. Select Automatically run a script of your choosing.
    4. Select the Run menu to display available choices.
      If the choices for the Run menu have been previously modified, the new run types won’t be visible. To add them:
      1. Select and hold (or right-click) Run and select Configure Choices.
      2. Select the missing choices for Run you want to add and select Add.Scheduled Job Run times options menu.

    Find child tables for scheduled jobs

    Identify child tables in scheduled jobs to promote consistent configuration across all related tables. This helps maintain data integrity and uniform processing logic throughout the table hierarchy.

    Vorbereitungen

    Role required: admin

    Warum und wann dieser Vorgang ausgeführt wird

    There are two ways to locate child tables of a scheduled job; either by running a script or using search parameters.

    Prozedur

    1. Wahlweise: Run a background script such as: gs.info(GlideDBObjectManager.get().getAllExtensions('sysauto'));

      The script is an efficient and thorough way to gather the names of all child tables to a parent table.

    2. Wahlweise: Search the sys_db_object_list table, using the search parameters: Extends table label starts with Scheduled Job or Extends table Extends table label starts with scheduled Job or Extends table Extends table Extends table label starts with scheduled jobs.

      Depending on the depth of the table hierarchy, additional parameters might be needed to find all child tables.