Mengambil Pekerjaan Scheduled SQL yang ditentukan.
Coba sekarang
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
log:GetScheduledSQL |
get |
*All Resource
|
None | None |
Sintaks permintaan
GET /scheduledsqls/{scheduledSQLName} HTTP/1.1
Path Parameters
|
Parameter |
Type |
Required |
Description |
Example |
| scheduledSQLName |
string |
Yes |
Nama unik dari Pekerjaan yang sudah ada. |
sql-123456789-123456 |
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| project |
string |
Yes |
Nama Proyek. |
ali-test-project |
Elemen respons
|
Element |
Type |
Description |
Example |
| ScheduledSQL |
Konfigurasi Pekerjaan Scheduled SQL. |
Contoh
Respons sukses
JSONformat
{
"description": "This is a scheduled sql job",
"displayName": "This is a scheduled sql job",
"name": "test-scheduled-sql",
"schedule": {
"type": "Cron",
"cronExpression": "0/5 * * * *",
"runImmediately": false,
"timeZone": "\"+0800\"",
"delay": 4,
"interval": "1m/1h"
},
"configuration": {
"script": "* | select *",
"sqlType": "searchQuery",
"destEndpoint": "cn-hangzhou-intranet.log.aliyuncs.com",
"destProject": "project-demo",
"sourceLogstore": "source-logstore-demo",
"destLogstore": "dest-logstore-demo",
"roleArn": "acs:ram::123456789:role/aliyunlogetlrole",
"destRoleArn": "acs:ram::123456789:role/aliyunlogetlrole",
"fromTimeExpr": "@m-1m",
"toTimeExpr": "@m",
"maxRunTimeInSeconds": 600,
"resourcePool": "enhanced",
"maxRetries": 20,
"fromTime": 1712592000,
"toTime": 0,
"dataFormat": "log2log",
"parameters": {
"test": "test",
"test2": 1
}
},
"createTime": 1714123644,
"lastModifiedTime": 1714123644,
"scheduleId": "e73f43732852064ad5d091914e39342f",
"status": "ENABLED"
}
Kode kesalahan
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 401 | AuthorizationRequired | Authorization Required |
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.