ALTER JOB

The ALTER JOB statement can supend, resume, or restart a job that is running on a cluster.

Syntax Summary

This code block is a quick reference with all the parameters that you can use with the ALTER JOB statement.

ALTER JOB job_name { SUSPEND | RESUME | RESTART }

The ALTER JOB statement accepts the following parameters.

The job_name parameter is required.

Parameter Description Example

Parameter	Description	Example
job_name	The name of the job to suspend, resume, or restart.
SUSPEND	Suspend the job. For details, see the API reference for the `suspend()` method.
RESUME	Resume a suspended job. For details, see the API reference for the `resume()` method.
RESTART	Suspends and resumes the job. For details, see the API reference for the `restart()` method.

job_name

The name of the job to suspend, resume, or restart.

SUSPEND

Suspend the job. For details, see the API reference for the suspend() method.

RESUME

Resume a suspended job. For details, see the API reference for the resume() method.

RESTART

Suspends and resumes the job. For details, see the API reference for the restart() method.

This section lists some example SQL queries that show you how to use the ALTER JOB statement.

You may want to suspend a job to perform maintenance on a source or a sink without disrupting the job.

ALTER JOB track_trades SUSPEND

When maintenance is finished, you can resume the job to restart it.

ALTER JOB track_trades RESUME

You may want to restart a job if you want to distribute it over some new members in your cluster and auto-scaling is disabled.

ALTER JOB track_trades RESTART