schedule_upgrade()#

relationalai.app
#schedule_upgrade(day_of_week STRING, task_time STRING)

A procedure that schedules the RelationalAI (RAI) Native App upgrade process to run at a specific time on a specific day of the week. Times are in the format HH:MM in the 24-hour clock and are in the UTC timezone. Requires the app_admin application role.

Parameters#

NameTypeDescription
day_of_weekSTRINGThe full or thre-letter day of the week (case-insensitive) to schedule the upgrade, e.g. 'WEDNESDAY' or 'WED'.
task_timeSTRINGThe time in UTC to schedule the upgrade, in the format HH:MM, e.g. '15:00’.

Returns#

STRING

Example#

Use the app.schedule_upgrade() procedure to schedule the RAI Native App upgrade process to run every week at a specified day and time:

#-- Schedule the upgrade to run every Wednesday at 15:00 UTC.
CALL relationalai.app.schedule_upgrade('WEDNESDAY', '15:00');
/*+-------------------------------------+
  | Upgrade task scheduled successfully |
  +-------------------------------------+ */

To change the upgrade schedule, call app.schedule_upgrade() with the new day and time. See Upgrades for more information on upgrading the RAI Native App.

See Also#