ALTER JOB statement can supend, resume, or restart a job that is running on a cluster.
ALTER JOB statement accepts the following parameters.
job_name parameter is required.
The name of the job to suspend, resume, or restart.
Suspend the job. For details, see the API reference for the
Resume a suspended job. For details, see the API reference for the
Suspends and resumes the job. For details, see the API reference for the
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