Locking/Unlocking Tables
Before Infoworks jobs are executed on a particular set of tables, the relevant tables can be locked according to the requirements to prevent accidental job submission for those tables, which might lead to data corruption. The lock can be released by performing an unlock operation on the tables whenever required.
Please note that once a table is locked, editing the table configurations for that table is disabled and the table configuration page turns to a read only section. Submission of any type of jobs on a particular table is prevented, once it has been locked.
Locking Infoworks Tables
Following are the steps to lock a set of tables to prevent accidental submission of jobs on the tables.
- Click the Admin menu and click the Sources icon. The Source list page with the list of all sources appears.
- Click on the source that contains the tables to be locked.
- Select the tables from the source that you want to lock and click on the red highlighted button with ‘Lock’ written on it.
- The success/error status will be displayed once the table lock operation has been executed.
Unlocking Infoworks Tables
Following are the steps to unlock a set of tables to resume submission of jobs on the tables.
- Click the Admin menu and click the Sources icon. The Source list page with the list of all sources appears.
- Click on the source that contains the tables to be unlocked.
- Select the tables from the source that you want to unlock and click on the green highlighted button with ‘Unlock’ written on it.
- The success/error status will be displayed once the table unlock operation has been executed.