| Parameter | Type | Description | Example |
|---|---|---|---|
| object | The detailed configurations of the Scheduled SQL job. | ||
| script | string | The query statement of the Scheduled SQL job. | * | select * |
| sqlType | string | The type of the query statement. | searchQuery |
| destEndpoint | string | The endpoint. | cn-hangzhou-intranet.log.aliyuncs.com |
| destProject | string | The destination project. | project-demo |
| sourceLogstore | string | The source Logstore. | source-logstore-demo |
| destLogstore | string | The destination Logstore. | dest-logstore-demo |
| roleArn | string | The Alibaba Cloud Resource Name (ARN) of the Resource Access Management (RAM) role that is assigned to the Scheduled SQL job. | acs:ram::123456789:role/aliyunlogetlrole |
| destRoleArn | string | The ARN of the RAM role that is assumed to write data to the destination Logstore. | acs:ram::123456789:role/aliyunlogetlrole |
| fromTimeExpr | string | The start time of the SQL time window. | @m-1m |
| toTimeExpr | string | The end time of the SQL time window. | @m |
| maxRunTimeInSeconds | long | The maximum timeout period of SQL analysis. Unit: seconds. Valid values: 60 to 1800. | 600 |
| resourcePool | string | The type of the resource pool. The value enhanced specifies an enhanced resource pool. | enhanced |
| maxRetries | long | The maximum number of SQL timeouts allowed. Valid values: 1 to 100. | 20 |
| fromTime | long | The beginning of the time range to query. For more information, see Process and store data from a Logstore to a Metricstore . | 1712592000 |
| toTime | long | The end of the time range to query. For more information, see Process and store data from a Logstore to a Metricstore . | 0 |
| dataFormat | string | The data format. Valid values: log2log, log2metric, and metric2metric. | log2log |
| parameters | object | The SQL configurations. For more information, see Process and store data from a Logstore to a Metricstore . | { addLabels: "{}", hashLabels: "[]", labelKeys: "[\"your label1\",\"your label2\"]", metricKeys: "[\"your Indicator1\",\"your Indicator2\"]", metricName: "", timeKey: "" } |