---
title: "Update the effective salary of the jobs"
manual: "Job board"
version: "main"
permalink: "https://docs.typo3.org/permalink/jweiland/jobboard:salary-update@main"
source: "Administration/SalaryUpdate.rst"
rendered: "2026-11-12T13:37:27+00:00"
---

# Update the effective salary of the jobs {#salary-update}

If the site setting [jobboard.salary.required](https://docs.typo3.org/permalink/jweiland/jobboard:confval-jobboard-salary-required@main) is enabled (the
default), the job list filters the jobs without salary information in the
database query. For this, every job stores its **effective salary**: the
lowest and
the highest amount that the frontend shows. The values are calculated from
the salary mode, the minimum and maximum salary and the valid salary grades
and steps of the job, with the same rules as the salary range of the
detail view, see [Salary tables, salary grades and salary steps](https://docs.typo3.org/permalink/jweiland/jobboard:editor-salary@main).

With this setting enabled, jobs without an effective salary are not
listed, and their detail view returns the HTTP status 404 (page not
found). With the setting disabled, these jobs are shown like all other
open jobs. The effective salary is calculated in both cases, so keep the
daily command running either way.

## Database columns {#salary-update-columns}

The table `tx_jobboard_domain_model_job` has these columns. Editors
see them read-only at the end of the first tab of a job, in the palette
**Effective salary**, as a control. They cannot be edited. The
values are updated when the job, a salary grade or a step is saved, and by
the scheduler task.

-   **`effective_salary_min`, `effective_salary_max`**

    Lowest and highest amount. A job is listed if one of them is greater
    than `0`.

-   **`effective_salary_valid_until`**

    Next point in time at which the publish date or expiration date of one
    of the salary grades or steps of the job changes the result. `0`
    means that no change is scheduled.

Translations of a job always get the values of the default language.

## Look-ahead of 24 hours {#salary-update-look-ahead}

A salary grade or step whose expiration date is within the next 24 hours
already counts as expired. Jobs that depend on such a grade disappear one
day before the grade expires. This gives editors a day to assign the
grades of the new pay scale, and a daily recalculation is enough to keep
all jobs up to date. A publish date in the future counts from the exact
point in time, without look-ahead.

## Update on saving records {#salary-update-datahandler}

A DataHandler hook
(`\JWeiland\Jobboard\Hook\UpdateEffectiveSalaryHook`) recalculates the
affected jobs whenever jobs, salary grades, salary steps or salary tables
are created, changed, hidden, deleted, restored, moved, copied or
localized. This also applies to the [job import](https://docs.typo3.org/permalink/jweiland/jobboard:import@main), which
saves all records with the DataHandler. Changes in a workspace are
calculated when they are published to the live workspace.

The values are written with the DataHandler as well, so
`TCEMAIN.clearCacheCmd` of the storage folder clears the cache
of the job board pages, see [Clear the cache of the job board pages](https://docs.typo3.org/permalink/jweiland/jobboard:configuration-page-tsconfig-cache@main).

## Daily update with the console command {#salary-update-command}

Publish and expiration dates of salary grades and steps take effect
without saving any record. The console command
`jobboard:salary:update` recalculates all jobs whose
`effective_salary_valid_until` is due within the next 24 hours.

**Recalculate the jobs with upcoming salary changes**

```bash
vendor/bin/typo3 jobboard:salary:update
```

> [!IMPORTANT]
> Run this command **once a day**, preferably at night. Create a task
> **Execute console commands** in the backend module
> **System > Scheduler** (EXT:scheduler), select
> `jobboard:salary:update` and set a daily frequency, for example
> the cron expression `30 2 * * *`. Alternatively, call the command
> with a cron job of your server.

The command writes only changed jobs, with the DataHandler. Therefore
`TCEMAIN.clearCacheCmd` of the storage folder also applies to
the nightly run.

The option `--all` recalculates every job. Run it once after
installing or updating the extension and after migrating records with an
upgrade wizard, see [After updating the extension](https://docs.typo3.org/permalink/jweiland/jobboard:upgrade-update@main):

**Recalculate the effective salary of all jobs**

```bash
vendor/bin/typo3 jobboard:salary:update --all
```