ores.scheduler.job_definition

Table of Contents

Metadata overlay for a pg_cron cron.job entry. Tracks the job name, cron expression, SQL command, target database, and active state.

Flags

Primary key

UUID primary key for the job definition.

Natural keys

Columns

party_id

Optional party scope for this job (NULL for tenant-scoped or system jobs).

job_name

Unique name for the scheduled job.

description

Human-readable description of the job.

command

SQL command to execute (used when action_type = execute_sql).

schedule_expression

Cron expression defining the schedule.

action_type

Execution mode: execute_sql or nats_publish.

action_payload

Payload for nats_publish action type.

is_active

1 = active, 0 = paused.

SQL

Flags

C++

Flags

Repository

Domain includes

#include <string>

Conventions

Qt

Detail fields

field label widget type is_key is_required placeholder
job_name Job Name jobNameEdit line_edit true true Enter unique job name
description Description descriptionEdit text_edit     Enter a human-readable description
command SQL Command commandEdit text_edit   true Enter the SQL command to execute
schedule_expression Schedule (cron) scheduleExpressionEdit line_edit   true e.g., 0 * * * * (every hour)
database_name Database databaseNameEdit line_edit   true Target PostgreSQL database name

Columns (Qt model)

enum_name field header type width
JobName job_name Job Name string 200
Description description Description string 250
Schedule schedule_expression Schedule string 150
DatabaseName database_name Database string 150
Active is_active Active bool 80
Version version Version int 60
ModifiedBy modified_by Modified By string 120

Custom repository methods

See also

Emacs 29.1 (Org mode 9.6.6)