Stopping, restarting and editing SQL jobs

As a SQL Stream job processes streaming data, you need to stop the job to finish the process. You can restart a SQL Stream job after stopping it. In case you need to update or change the configurations set for a SQL Stream job, you can restart it. You can navigate through the job life cycle using the Streaming SQL Console.

Stopping a SQL Stream job

1. Select Console from the left hand menu.
2. Click on the SQL Jobs tab.
3. Click on the red stop button for the job you would like to stop.

Restarting a SQL Stream job

1. Select Console from the left hand menu.
2. Click on the SQL Jobs tab.
3. Click on the select box below the State column.
4. Select Cancelled or Failed to see stopped jobs.
5. Select the job you would like to restart.
6. Select the Details tab at the bottom.
7. Select the Edit Selected Job button.

   The SQL window in Edit Mode appears.

8. Select Restart to restart the job.

Editing a SQL Stream job

1. Select Console from the left hand menu.
2. Click on the SQL Jobs tab.
3. Select the job you would like to edit.
4. Select the Details tab at the bottom.
5. Select the Edit Selected Job button.

   This will bring up the SQL window in Edit Mode.

6. Edit the Target Deployment, Sink Virtual Table and the SQL itself as needed.
7. Select Restart to restart the job.

   The job will be stopped and restarted.