Lists schedules declared in the current session, optionally filtered by a LIKE pattern.
SHOW SCHEDULES [LIKE '<pattern>']## Overview SHOW SCHEDULES returns one row per schedule declared in the current session via the SCHEDULE statement. ## Behavior - The result reflects only the executor's in-session `declared_schedules` registry. - The optional LIKE clause filters by name using SQL wildcards. The match is case-insensitive. - Result columns include the schedule name, cron expression, timezone, retries, timeout, max_concurrent, and lifecycle flags as supplied at declaration time. ## Access Control No specific privilege is required. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
pattern | Optional case-insensitive LIKE pattern. |
-- List every schedule declared in this session
SHOW SCHEDULES;-- Filter by suffix
SHOW SCHEDULES LIKE '%_etl';