...
ALTER SCHEDULED QUERY <scheduled_query_name>
(<scheduleSpec>|<executedAsSpec>|<enableSpecification>|<definedAsSpec>|<executeSpec>);
Drop syntax
DROP SCHEDULED QUERY <scheduled_query_name>;
...
The “query” is a single statement expression to be scheduled for execution.
Anchor | ||||
---|---|---|---|---|
|
EXECUTE
Changes the schedules next execution time to be now. Could be useful during debugging/development.
System tables/views
Informations about scheduled queries/executions can be obtain by using the information_schema or the sysdb - recommended way is to use the information_schema; sysdb is tables are there to build the information_schema level views - and for debugging.
...