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.
See some practical 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 |
|
RESUME |
Resume a suspended job. For details, see the API reference for the |
|
RESTART |
Suspends and resumes the job. For details, see the API reference for the |
Examples
This section lists some example SQL queries that show you how to use the ALTER JOB
statement.