On the Scheduled SQL page in the 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.
- Log on to the Log Service console.
- In the Projects section, click the name of the project that you want to view.
- In the left-side navigation pane, choose .
- 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 Task ID.
View the instances of the Scheduled SQL job
When the Scheduled SQL job is run, 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.
|Instance ID||The unique identifier of the Scheduled SQL instance.|
|Task Running 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 involved in SQL analysis. The following information is displayed:
|Status||The status of the Scheduled SQL instance. Valid values: Running, Retrying, Success, and Failed.|
Retry an instance of the Scheduled SQL job
Delete the Scheduled SQL job
If you no longer need to use the Scheduled SQL job, you can click Delete in the upper-right corner of the Scheduled SQL page.
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 Import data from Logstore to Logstore, Import data from Logstore to Metricstore, or Import data from Metricstore to Metricstore.