Monitoring SQL Stream jobs

You can use the Streaming SQL Console to review the status, properties and log of your SQL Stream jobs executed in SQL Stream Builder. Using the Flink Dashboard, you can also monitor the Flink job that is submitted when you execute a SQL query.

Using the Streaming SQL Console

When using the SQL Jobs page in Streaming SQL Console to monitor your SQL jobs, you can review the ID, the Name, the Start time, the State of the submitted jobs, and the User who submitted the SQL jobs. When monitoring running jobs, you are also able to open the Flink Dashboard, and stop the job using the Stop button under Actions. The Flink Dashboard link and Stop button are not available for Stopped Jobs.
  1. Click Console on the main menu.
  2. Select SQL Jobs tab.
    By default, Running Jobs are displayed on the SQL Jobs page.
  3. Select Running Jobs or Stopped Jobs from the drop-down menu.
  4. Click on the job you want to monitor.
    1. You can further filter down the results, by directly searching for the job name in the Search field.
  5. Select Details tab on the bottom panel to display additional details and configurations about the SQL job.
  6. Select Log tab on the bottom panel to review the log information of the job submission.

History of SQL queries

You can review and reuse the SQL queries that were previosuly executed on the History page. When you click on one of the SQL queries, it is automatically imported to the SQL window for execution. You can filter the SQL queries by the time they were last run or by the user who run them. You can also search for a type of SQL query using the Search field.

Using the Flink Dashboard

You can also monitor your running SQL jobs using the Flink Dashboard. You can easily reach the Flink Dashboard on the SQL jobs tab below the Console main menu. After clicking on the Flink Dashboard, you are redirected to the Flink Dashboard interface.