Schedule or execute a job to update records

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • Schedule a date and time to execute an update job or execute the job immediately.

    Avant de commencer

    Role required: admin

    Pourquoi et quand exécuter cette tâche

    Consider scheduling the update job to run during non-business hours to minimize the potential performance impact on your users. Updating a large number of records can degrade performance depending on the size of the table. On instances running MariaDB, UPDATE operations affecting a majority of rows may trigger gap locks, escalating to a full table lock until the update completes. INSERT operations are not affected by this locking behavior.

    Procédure

    1. Navigate to All > System Data Management > Update jobs.
    2. Select an update job record.
    3. Determine whether to schedule the update job for a later time or run it right away.
      OptionDescription
      Schedule the update job
      1. Select the calendar icon in the Run at field.
      2. Enter the date and time you want the update job to run.
      3. Select Update. Note that you must select Update to successfully schedule the job.
      Run the update job now
      1. Select Execute Now to run the update job immediately.
      2. When prompted, select Proceed to update the records now.
      3. On the Progress page, select Cancel to stop the job from continuing to run.
      4. Select Check execution results to return to the update job form.

    Résultats

    The records are scheduled for update or updated immediately. If you want to revert the updates to the records, see Rollback an update job.