Save and schedule

Save a query when you want to run it again. Schedule it when you want Yorlet to run it and email a CSV without opening Prism. The Queries tab in the side panel has Saved, Scheduled, and Run history. Click New to start from a blank editor.

​

Save a query

To save a query, follow these steps:

1. Open Prism.
2. Write or pick the SQL, and give it a name by clicking the title.
3. Click Save.

If the query already has a name and you have changed the SQL, the button reads Save changes. The Saved list shows queries under By you. Click a query to load it. The subtitle under the title shows when it was saved, and unsaved changes when the editor no longer matches.

​

Run history

Run history lists recent runs. Click a run to load its SQL. If it succeeded, the result is shown as well. If the run belonged to a saved query, Prism also selects that saved query.

​

Schedule a query

A schedule runs a saved query on a cron cadence and emails a CSV of the results. Standard allows 5 schedules. Premium has no cap. To create a schedule, follow these steps:

1. Save the query first.
2. Click Schedule.
3. Enter a Cron expression, for example 0 8 * * 1 for 08:00 every Monday (UTC).
4. Enter Recipients (comma separated).
5. Click Create schedule.

Existing schedules for this query appear in the same panel. Click Pause or Resume. The Scheduled list in the side panel also shows Active or Paused, the expression, and how many recipients.