Structure of mailing_run

Holds dynamic information about the mailing. The mailing batch launched by manitou-mdx updates this table on every new message being generated and sent for the mailing identified by mailing_id.

mailing_id

integer REFERENCES mailing_definition

Unique identifier of the mailing.

status

smallint

0=not started, 1=running, 2=stopped, 3=finished

throughput

double precision

The delay between two consecutive sending of messages, expressed in seconds. It is used to avoid flooding the mail subsystem.

nb_total

integer

The total number of messages for this mailing.

nb_sent

integer

The current number of messages sent for this mailing.

last_sent

timestamp with time zone

The date and time of the last sending for this mailing.