Manage a Scheduled SQL job - Simple Log Service - Alibaba Cloud Documentation Center

On the Scheduled SQL page in the Simple Log Service console, you can view the basic information about a Scheduled SQL job and the instances of the Scheduled SQL job. You can also retry, modify, or delete the Scheduled SQL job.

Prerequisites

A Scheduled SQL job is created. For more information, see Process and save data from a Logstore to another Logstore, Process and store data from a Logstore to a Metricstore, or Process and save data from a Metricstore to another Metricstore.

Procedure

Log on to the Simple Log Service console.
In the Projects section, click the project that you want to manage.
In the left-side navigation pane, choose Job Management > Scheduled SQL.
Click the Scheduled SQL job.

View the basic information about the Scheduled SQL job

In the Basic Information section, you can view the basic information about the Scheduled SQL job, including Created At, Last Modified At, and Job ID.

SQL作业

View the instances of the Scheduled SQL job

When the Scheduled SQL job is run, Simple Log Service generates instances based on the scheduling interval that you specify. You can view all instances of the Scheduled SQL job in the Instances section. The following table describes the parameters.

执行实例

Parameter	Description
Instance ID	The unique identifier of the Scheduled SQL instance.
Job Execution Time	The time range during which the Scheduled SQL instance is run.
SQL Query Range	The time range that you specify for SQL analysis. The instance analyzes the data that is generated within the time range.
Processed Data Size	The size of the data that is involved in SQL analysis. The following information is displayed: Processed Rows: the number of logs that the instance reads within the specified SQL time window. This parameter indicates the amount of data that is used in computation. Result Rows: the number of logs in the analysis results. This parameter indicates the amount of data that is written to the destination Logstore or Metricstore. Processed Date Size: the number of bytes of logs that the instance reads within the specified SQL time window. This parameter indicates the amount of data that is used in computation. Rows Written to Destination Logstore: the number of logs that are obtained from the analysis results and written to the destination Logstore or Metricstore. This parameter indicates the amount of data that is written to the destination Logstore or Metricstore.
Status	The status of the Scheduled SQL instance. Valid values: Running, Retrying, Success, and Failed.

Retry an instance of the Scheduled SQL job

If an instance of the Scheduled SQL job is in the Success or Failed state, you can run the instance again. To process historical data, you can retry successful instances. However, we recommend that you proceed with caution. In most cases, you need to only retry the failed instances of a Scheduled SQL job.

If an instance of the Scheduled SQL job is in the Failed state, you can move the pointer over the icon to view the cause of the failure and troubleshoot the issue, and click Retry in the Actions column.

Delete the Scheduled SQL job

If you no longer require the Scheduled SQL job, you can click Delete Job in the upper-right corner of the Scheduled SQL page.

Warning

After you delete the Scheduled SQL job, the job cannot be restored. Proceed with caution.

Modify the Scheduled SQL job

To modify the settings of the Scheduled SQL job, click Modify Settings in the upper-right corner of the Scheduled SQL page. For more information about the parameters, see Process and save data from a Logstore to another Logstore, Process and store data from a Logstore to a Metricstore, or Process and save data from a Metricstore to another Metricstore.