The TERMINATE statement stops a stream job.
Engine and version
The TERMINATE statement applies only to the stream engine and requires version 3.1.8 or later.
Note
You can view the current version and perform a minor version update in the console.
Syntax
terminate_job_statement ::= TERMINATE JOB job_nameUsage notes
job_name specifies the name of a running stream job. You can use the DESCRIBE statement to confirm that the job status is RUNNING.
Examples
Stop the job test_datagen2.
TERMINATE JOB test_datagen2;Verify the result
Run the SHOW JOBS; command to view the status of test_datagen2. After the statement is successfully executed, the Job Status is displayed as CANCELED.