Manage a Scheduled SQL job-Simple Log Service(SLS)-阿里云帮助中心

Prerequisites

A Scheduled SQL job is created. Create a Scheduled SQL job to import data from a Logstore to a Logstore, Create a Scheduled SQL job to import data from a Logstore to a Metricstore, or Create a Scheduled SQL job to import data from a Metricstore to a Metricstore.

Procedure

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

Basic information

The Basic Information section displays the job creation time, last modification time, and job ID.

It also shows the Source Project/Logstore, Destination Project/Logstore, job name, and job description.

Execution instances

Simple Log Service creates execution instances based on the scheduling interval. View all instances in the Instance section.

Parameter	Description
Instance ID	Unique identifier of the instance.
Job Execution Time	Time when the instance ran.
SQL query range	Time range of data analyzed by the SQL query.
Processed Data Size	Data processed by the SQL analysis. Includes the following metrics: Processed Rows: Number of log rows read within the SQL time window for computation. Result Rows: Number of log rows in the result set after SQL analysis. Processed Data Size: Size (in bytes) of logs read within the SQL time window for computation. Rows Written to Destination Logstore: Number of result rows written to the destination Logstore.
Execution Status	Status of the instance. Valid values: Running, Retrying, Succeeded, and Failed.

Retry an instance

You can retry an instance with a Succeeded or Failed status. Retrying a successful instance is useful for data backfilling but requires caution. Typically, only failed instances need retrying.

If an instance fails, hover over the icon to view the failure reason. After resolving the issue, click Retry.

For example, ExportFailed LogStoreNotExist:logstore sql-test does not exist indicates the destination Logstore does not exist. Create the Logstore before retrying.

Delete a job

To delete a Scheduled SQL job, click Delete in the upper-right corner of the management page.

Warning

Deleted Scheduled SQL jobs cannot be restored.

Modify a job

To modify a Scheduled SQL job, click Modify Configuration in the upper-right corner of the management page. The configurable parameters are described in Create a Scheduled SQL job to import data from a Logstore to a Logstore, Create a Scheduled SQL job to import data from a Logstore to a Metricstore, or Create a Scheduled SQL job to import data from a Metricstore to a Metricstore.