This is a prerelease version.

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.

For some practical examples, see << examples, Code Examples>>.
ALTER JOB job_name { SUSPEND | RESUME | RESTART }

Parameters

The ALTER JOB statement accepts the following parameters.

The job_name parameter is required.

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.

Examples

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

Suspend and Resume a Job

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

Restart a Job

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