Kinetica provides support for basic SQL procedures, as an executable batch
of SQL statements. A SQL procedure can be executed by two means:
on-demand - called directly by a user
scheduled execution - configured, upon creation, to execute at a
user-specified interval
Even if a SQL procedure is configured for scheduled execution, it
can still be executed directly by a user in on-demand fashion.
After the first run, the execution plan for all statements in the
SQL procedure will be created and cached to improve performance on future
executions.If there is an error executing any statement, the SQL procedure will stop
immediately and report the error. If it is invoked via scheduled execution,
an alert will be sent to the alert monitor, as
there is no interactive session through which the error could be reported to a
user. Any database modifications prior to the error will not be rolled back.
If any of the database objects referenced in the SQL procedure are
dropped or modified, the SQL procedure will be dropped as well. This does
not include any objects created by the SQL procedure that are later
referenced by it.
