ALTER PROCEDURE - Kinetica Docs

Alters the configuration of an existing SQL procedure. The following facets of a SQL procedure can be altered:

Set Execution User

A SQL procedure can have its execution user modified.

ALTER PROCEDURE SET EXECUTE AS Syntax

ALTER PROCEDURE [<schema name>.]<procedure name>
SET EXECUTE AS '<user name>'

Examples

To set the execution user of the sqlp_ea SQL procedure to spuser:

ALTER PROCEDURE SET EXECUTE AS Example

ALTER PROCEDURE example.sqlp_ea
SET EXECUTE AS 'spuser'

Set Execute Mode

The refresh mode of a SQL procedure can be modified.

ALTER PROCEDURE SET EXECUTE MODE Syntax

ALTER PROCEDURE [<schema name>.]<procedure name>
SET EXECUTE [FOR] EVERY <number> <SECOND[S] | MINUTE[S] | HOUR[S] | DAY[S]>
    [STARTING AT '<YYYY-MM-DD [HH:MM[:SS]]>']
    [STOP AFTER < '<YYYY-MM-DD [HH:MM[:SS]]>' | <number> <SECOND[S] | MINUTE[S] | HOUR[S] | DAY[S]> >]

Parameters

EXECUTE FOR EVERY

Specify an interval in seconds, minutes, hours, or days at which the SQL procedure should be executed.By default, the first execution interval will be one interval’s worth of time from the point at which the SQL procedure alteration was requested.

STARTING AT

Specify a date or timestamp at which refresh cycles should begin.

STOP AFTER

Specify a date, timestamp, or time interval after which refresh cycles should end.

Examples

To alter the sqlp_em SQL procedure to execute every 6 hours:

ALTER PROCEDURE Set Execution Mode Example

ALTER PROCEDURE example.sqlp_em
SET EXECUTE FOR EVERY 6 HOURS

To alter a SQL procedure to execute every minute in January, 2026:

ALTER PROCEDURE Set Execution Start/Stop Example

ALTER PROCEDURE example.sqlp_em
SET EXECUTE FOR EVERY 1 MINUTE
    STARTING AT '2026-01-01 00:00:00'
    STOP AFTER 31 DAYS

​Set Execution User

​Examples

​Set Execute Mode

​Parameters

​Examples

Set Execution User

Examples

Set Execute Mode

Parameters

Examples