locking table - SuperOffice

locking Table (380)

Generic locking and error messages

Fields

Name	Description	Type	Nullable
id	Primary key	PK	No
status	Current status	status	Yes
stop	Signal to stop schedule	Bool	No
last_execution	Last execution	DateTime	Yes
execution_time	Amount of time in seconds used by last execution	Int	Yes
lock_expire	Lock preventing the same schedule to run simultaniously	DateTime	Yes
lock_pid	PID preventing the same schedule to run simultaniously	Int	Yes
lock_ttl	Lock time to live	Int	Yes
error_message	Last error message	Clob	Yes
last_error	Time of last error	DateTime	Yes
retries	Number of retries since last successfull execution	Int	No

Indexes

Fields	Types	Description

Relationships

Table	Description
inbox	Info and status for safe email import

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

inbox table schedule table scheduled_task table Protected tables dbi_agent_schedule table Enum DocumentLockSemantics

⌘I