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 that you have 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
- Select Console from the left hand menu.
- Go to the SQL Jobs tab.
- Click red stop corresponding the job you would like to stop.
Restarting a SQL Stream job
- Select Console from the left hand menu.
- Go to the SQL Jobs tab.
- Select Cancelled or Failed from the State drop-down menu to see the stopped jobs.
- Select the job you want to restart.
- Go to the Details tab at the bottom.
- Click Edit Selected Job .
The SQL window in Edit Mode appears.
- Click Restart .
Editing a SQL Stream job
- Select Console from the left hand menu.
- Go to the SQL Jobs tab.
- Select the job you want to edit.
- Go to the Details tab at the bottom.
- Click Edit Selected Job .
This brings up the SQL window in Edit Mode.
- Edit the Target Deployment, Sink Table, and the SQL itself as needed.
- Select Restart to restart the job.
The job will be stopped and restarted.