Query Automation
When you login to the database, you can view [Query plan] under [Job automation] in the navigation tree. The [Add Query Plan] and [Auto Query Logs] menus will appear when you right-click [Query plan].
If you want to execute a backup periodically with the CUBRID Manager, configure the values of [Add Query Plan]. The DBA can configure the backup automation while the Manager server is running. It is not affected by whether the database is running or not. That is, backup automation is executed only when the Manager server is running.
Add Query Plan

- Query Plan ID : Enter the name of the query job. The query plan ID must be unique in the database because multiple query plans may exist in the same database.
- User name/password : Enter the user name, which will execute the registered query automatically, and its password. If you enter wrong information, the query is not automatically executed. Therefore, you must change the user information in the [Edit Query Plan] in case of password change.
- Period type : You can select a query automation period from options of Monthly, Weekly, Daily and A specific day.
- Period detail : You can set details for the period type you selected.
- Query hour : Enter the time when the query is to be executed automatically. You must enter the time in hour and minute.
- Query Statement : Enter the query statement to be executed automatically. Note that the registered query is executed automatically at the specified time, but the execution results are not recorded.
- Check Query : Check query errors before registering the auto-executed query statement. It determines whether it is an error or not by creating query plan it does not actually execute the query. It is working like executing optimization level 514 in the CSQL Interpreter.
Auto Query Log
You can view a log about queries that are automatically executed in the [Auto Query Logs]. Information such as a database, user ID, query ID, query hour, and error code (success : 0, failure : -1) is recorded.

Edit/Delete Query Plan
If you register a query job whose ID is every_mon_delete, the < every_mon_delete> item is added under the [Query plan]. You can view the [Edit Query Plan] and [Delete Query Plan] menus by right-clicking the item. With these menus, you can edit or delete the query plan.