Schedule or execute a job to update records

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.

   Option	Description
   Schedule the update job	Select the calendar icon in the Run at field. Enter the date and time you want the update job to run. Select Update. Note that you must select Update to successfully schedule the job.
   Run the update job now	Select Execute Now to run the update job immediately. When prompted, select Proceed to update the records now. On the Progress page, select Cancel to stop the job from continuing to run. 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.