Skip to main content

Getting started

A first job: refresh a summary table every night, then run it by hand to check it.

At a glance​

Nomaflow · JobsFilter…+ New jobcrm-stalled-dealsFlags deals without news0 8 ∗ ∗ 0-4SUCCEEDED● onRun nowRun with parameterssales-copyjdedwards → warehouse30 2 ∗ ∗ ∗FAILED● onRun nowRun with parameters+ New jobopens the job editorA job cardschedule, last run stateRun nowruns it at onceLast run failedclick it for the detail

Before you start​

  • A superuser account — the Jobs pages are reserved to superusers.
  • A SQL connector with a write query that does the work, for instance daily_summary_refresh (INSERT … SELECT …, REFRESH MATERIALIZED VIEW …, CALL …). A step calls a named query of a connector, not SQL typed in the job. See Create a custom query.

1 — Open the Jobs page​

Open Jobs from the Nomaflow menu (address /nomaflow). Each job is a card; the toolbar has + New job and Schedule. See Jobs page.

2 — Create the job​

+ New job. In the Job section: Id daily-summary, a Description, the tag reporting, Enabled on.

3 — Add a step​

In Steps, the Add step: bar: click sql_query. Give the step a Step name (refresh-summary), pick the Connector, then the Query daily_summary_refresh.

4 — Set the schedule​

Back in the Job section: Schedule (cron) 0 2 * * *, Timezone Europe/Paris. Next runs lists the next five nights — check them. Then Save at the top: the job appears on the Jobs page with its next run.

5 — Run it by hand​

On the card, ▶ Run now. The card shows the run in progress, then last SUCCEEDED; click it to open the run detail: the summary, the step with its state, the rows affected and the log. See Run history.

6 — Be told when it fails​

In Liberty Next → Build → Notifications, add a rule: trigger A job event, job daily-summary, events failure and missed, channel email, recipient role:ops. See Notifications.

What next​

  • More step types — loading files, copying tables, calling an API: Steps.
  • Run the same job with different parameters on several schedules: Schedulable presets.
  • Ready-made patterns: Workflow recipes.