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

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

Restarting a SQL Stream job

  1. Select Console from the left hand menu.
  2. Go to the SQL Jobs tab.
  3. Select Cancelled or Failed from the State drop-down menu to see the stopped jobs.
  4. Select the job you want to restart.
  5. Go to the Details tab at the bottom.
  6. Click Edit Selected Job .

    The SQL window in Edit Mode appears.

  7. Click Restart .

Editing a SQL Stream job

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

    This brings 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.