---
title: "Transform jobs"
description: "Run transforms on schedule."
url: "https://www.metabase.com/docs/latest/data-modeling/transforms/jobs-and-runs"
version: "65"
---

> For the complete documentation index, see [llms.txt](https://www.metabase.com/docs/llms.txt).

# Transform jobs

_Data Studio > Data transformation > Jobs_

Jobs are scheduled runs of transforms based on the transform's tags.

## Transform tags

![Transform tags](https://www.metabase.com/docs/latest/data-modeling/images/tags.png)

Add tags to transforms so that you can use jobs to run the transforms on a schedule. For example, you could add a "Nightly" tag to a transform, and have a job that runs all the transforms with the "Nightly" tag at midnight every day.

To add a tag to a transform:

1. Make sure you have [permissions to edit transforms](https://www.metabase.com/docs/latest/data-modeling/transforms/transforms-overview.md#permissions-for-transforms).
2. Visit the transform in **Data Studio > Data transformation**.
3. On the **Settings** page for a transform, add transform tags.

By default, Metabase comes with hourly, daily, weekly, and monthly tags and jobs that are run on the corresponding schedules, but you can remove or rename those tags, or create new tags. To create a new tag, just type the new tag's name in **Tags** field (either when viewing a transform or when viewing a job) and select **Create a tag**.

Once you've tagged a transform, you can create a job that uses that tag to run the transform on the job's schedule.

## Jobs

![Transform jobs](https://www.metabase.com/docs/latest/data-modeling/images/jobs.png)

Jobs run one or more transforms on schedule based on transform tags.

Jobs have two components: schedule and tags.

- **Schedule** determines when the job will be executed: daily, hourly, etc. You can specify a custom cron schedule (e.g. "Every weekday at 9:05 AM"). Jobs run in your Metabase's [report timezone](https://www.metabase.com/docs/latest/configuring-metabase/localization.md#set-default-instance-report-timezone), or in the system timezone if no report timezone is set.
- **Tags** determine _which_ transforms a job runs, not when the job runs. For example, you can create a `Weekdays` tag, add that tag to a few transforms, then create a job that runs all the transforms with the `Weekdays` tag every weekday at 9:05AM.

Jobs will run all transforms tagged with any of the tags, plus any transforms that the tagged transforms depend on that aren't already up to date, see [Jobs include all dependent transforms](#jobs-include-all-dependent-transforms).

You can see which transforms a job will run and in which order on the job's page.

### Create a job

To create a new job:

1. Go to **Data Studio > Data transformation > Jobs**
2. Click the **+ New** button in the top right.
3. Specify the schedule: select one of the built-in schedules or use cron syntax to specify a custom schedule,

   ![Jobs schedule](https://www.metabase.com/docs/latest/data-modeling/images/jobs-schedule.png)

   Job can use multiple tags, and will run all transforms that have _any_ of those tags. For example, you can have a job "Weekend job" that is scheduled run at noon on Saturdays and Sundays that picks up all transforms tagged either "Saturday", "Sunday", or "Weekend".

### Disable jobs

You can disable a job without deleting it. A disabled job keeps its tags and schedule but won't run until you re-enable it, which is handy when you're debugging.

To disable a specific job:

1. Go to **Data Studio > Data transformation > Jobs**.
2. Find the job you want to disable and click the **three dots** icon to the right of the job's name.
3. Select **Disable**

To disable all jobs:

1. Go to **Data Studio > Data transformation > Jobs**.
2. Click the **three dots** icon above the table with all the jobs, and select **Disable all**.

   ![Disable all jobs](https://www.metabase.com/docs/latest/data-modeling/images/disable-all-jobs.png)

Even if you disable all jobs, new jobs will still be created enabled by default.

### Re-enable jobs

To re-enable a job, follow the [steps for disabling jobs](#disable-jobs) and select **Re-enable** (or **Re-enable all**).

### Delete a job

Deleting a job will not delete any transforms.

Deleted jobs can't be restored. If you want to temporarily stop a job from running, consider disabling the job instead.

To delete a job:

1. Go to **Data Studio > Data transformation > Jobs**.
2. Find the job you want to delete and click the **three dots** icon to the right of the job's name.
3. Select **Delete**.

## Jobs include all dependent transforms

If one transform depends on another, Metabase adds the dependency to the job and runs it first, even if that transform isn't tagged in the job. So if transform B depends on A, Metabase makes sure A is up to date before running B.

## Jobs skip dependencies that are already up to date

Metabase won't re-run a dependency that's still fresh. That way, a transform pulled into a frequent job doesn't get rebuilt more often than its own schedule calls for. So, for example, if you tag transform A `daily`, and transform B `hourly`, and hourly B depends on daily A, then A runs on its own daily schedule. The hourly job that runs B won't rerun A every hour.

Metabase skips a dependency when the dependency:

- Has its own tags and jobs, and none of those jobs' schedules have come due since the dependency last ran successfully.
- Has no tags at all, and it's already run successfully at least once.

## See which transforms a job will run

The job's page in **Data Studio > Data transformation > Jobs** lists every transform the job will run and in which order. The **Notes** column tells you when Metabase will skip a dependency, and flags dependencies that have no schedule of their own.

Metabase runs up to three query-based transforms (SQL or query builder) from a job at the same time, and Python transforms one at a time. A transform still waits for the transforms it depends on. On self-hosted Pro and Enterprise plans, you can change how many query-based transforms run at once with the [`MB_TRANSFORM_RUN_JOB_SQL_CONCURRENCY`](https://www.metabase.com/docs/latest/configuring-metabase/environment-variables.md#mb_transform_run_job_sql_concurrency) environment variable.

## Runs

![Transform runs](https://www.metabase.com/docs/latest/data-modeling/images/runs.png)

You can see all past and current transform runs (both manual and scheduled) in **Data Studio > Data transformation > Runs**. Run times are in your Metabase server's timezone (hover the info icon next to **Started at** to see which).

If a transform run takes longer than four hours, Metabase stops it and marks it as timed out. On self-hosted Pro and Enterprise plans, you can change this limit with the [`MB_TRANSFORM_TIMEOUT`](https://www.metabase.com/docs/latest/configuring-metabase/environment-variables.md#mb_transform_timeout) environment variable.

You can click on any transform run to see more details about the run, like the error logs. To go to the transform definition from the transform run page, click on the icon next to the transform name in the right sidebar.

The "Tags" column in the **Runs** table will only show the transform's specific tags. But the run might not have anything to do with those tags. Another job with different tags could have run the transform because [jobs include all dependent transforms](#jobs-include-all-dependent-transforms).

## Emails about failed transforms

If your Metabase is [set up to send email](https://www.metabase.com/docs/latest/configuring-metabase/email.md), Metabase will let people know when transforms fail.

- **Individual transform failures**: when transforms fail during a scheduled job run, Metabase emails the last person to edit each failed transform (or the transform's creator, or admins if neither is active). Each email covers a single job run.
- **Daily digest of job failures**: each morning, Metabase emails all admins a summary of the scheduled job runs that failed or timed out the previous day. Manual runs aren't included in the digest, and Metabase skips the email entirely if no scheduled runs failed.
