Native SQL Tasks¶
MatrixOne v4.2.5 stores named SQL jobs inside the database. Run them on a cron schedule or manually with EXECUTE TASK. Tasks support WHEN gates, retries, body timeouts, suspension, resumption, and run history.
Use them for scheduled aggregation, cleanup, batch writes, or calling stored procedures. This MatrixOne SQL capability is independent of MySQL’s event_scheduler; lack of MySQL EVENT support does not imply lack of native SQL Tasks. External tools such as DolphinScheduler can orchestrate cross-system DAGs and programs.
A multi-statement Task body is not one atomic transaction. Earlier writes may survive a failure and retries may repeat them. Use idempotent SQL and inspect history and business watermarks.