Skip to content

relationalai.api.alter_engine_auto_suspend_mins()

alter_engine_auto_suspend_mins(name STRING, auto_suspend_mins INT)

A procedure that sets the number of minutes of inactivity before the specified RelationalAI (RAI) engine is automatically suspended. Requires the eng_admin application role.

NameTypeDescription
nameSTRINGThe name of the engine to update (case-sensitive).
auto_suspend_minsINTThe number of minutes of inactivity before the engine is automatically suspended. Use 0 to never suspend the engine.

STRING

Use the api.alter_engine_auto_suspend_mins() procedure to set the auto-suspend time for an engine:

-- Set the auto-suspend time for the engine 'my_rai_engine' to 30 minutes.
CALL relationalai.api.alter_engine_auto_suspend_mins('my_rai_engine', 30);
/*+---------+
| Success |
+---------+ */