Enable run types for scheduled job child tables

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • 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.

    Before you begin

    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: system_scheduler_admin

    Procedure

    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 choices for Run that you want to add and select Add.

    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.

    Before you begin

    Role required: system_scheduler_admin

    About this task

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

    Procedure

    1. Optional: 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. Optional: 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.