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

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.