Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

setautoexecquery


Version 9.2.0

 

Description

Get databases' information in cubrid.

 

Request Json Syntax

Key Description
task task name
token token string encrypted.
dbname database name
planlist auto-query plan list
queryplan auto-query plan
query_id auto-query id
period the cycle of auto-query, such as weeky, monthly, everyday and "one".
detail auto-query time (or interval,start with "i", the measurement is minutes)
query_string sql statement

 

Request Sample

{"task":"setautoexecquery",
"token":"cdfb4c5717170c5e99586a2763e2b6dce92982faacefb068d7e5a24b9c5fa0a37926f07dd201b6aa",
"dbname":"demodb",
"planlist":{
"queryplan":[{"query_id":"bbaa",
"username":"dba",
"userpass":"none",
"period":"ONE",
"detail":"2013/01/16 17:17" ("2013/01/16 i17",),
"query_string":"select * from code;"}
}]
}

 

Response Json Syntax

Key Description
task task name
status execution result, success or failed.
note if failed, a brief description will be given here

Response Sample

{
   "__EXEC_TIME" : "396 ms",
   "note" : "none",
   "status" : "success",
   "task" : "setautoexecquery",
}
comments powered by Disqus
Page info
viewed 382 times
translations en
Author
posted last year by
cheeray
Contributors
updated last year by
View revisions
Share this article