locking Table (380)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Generic locking and error messages
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | Primary key | PK | |
| status | Current status | status | ● |
| stop | Signal to stop schedule | Bool | |
| last_execution | Last execution | DateTime | ● |
| execution_time | Amount of time in seconds used by last execution | Int | ● |
| lock_expire | Lock preventing the same schedule to run simultaniously | DateTime | ● |
| lock_pid | PID preventing the same schedule to run simultaniously | Int | ● |
| lock_ttl | Lock time to live | Int | ● |
| error_message | Last error message | Clob | ● |
| last_error | Time of last error | DateTime | ● |
| retries | Number of retries since last successfull execution | Int |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
Relationships
| Table | Description |
|---|---|
| inbox | Info and status for safe email import |
Replication Flags
- None
Security Flags
- No access control via user's Role.