> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# locking table

> Generic locking and error messages

## 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    |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/locking.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=792c44519ecd476c1cff8a2c86d24a71" alt="locking table relationship diagram" width="335" height="59" data-path="media/loc/en/database/tables/locking.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table            | Description                           |
| ---------------- | ------------------------------------- |
| [inbox](./inbox) | Info and status for safe email import |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [inbox table](/en/database/tables/inbox.md)
- [schedule table](/en/database/tables/schedule.md)
- [scheduled_task table](/en/database/tables/scheduled-task.md)
- [Protected tables](/en/api/bulk-operations/mass-operations/protected-tables.md)
- [dbi_agent_schedule table](/en/database/tables/dbi-agent-schedule.md)
- [What's new in version 10.1.2.686](/release-notes/database/changes-10.1.2.md)