Resolution:
The only data managers tables used by jobs are "job", "global" and "duplicates". The remaining are for internal engine use and are not updated per job. This includes the "internal" table which is not used for storing any job related data.

* Job table
- Used when job checkpoint is enabled.
- Row gets inserted when job is created and removed when job is completed.
- Row gets updated each time a checkpoint is taken.
- Row gets updated if job migration occurs (for load balancing or fault tolerance purposes).
- Table is read at engine startup time to load checkpointed jobs.

* Duplicates table
- Used if duplicate detection is enabled on a job creator.
- Table is scanned for a matching duplicate key each time a new job is created.
- Row gets inserted if a non-duplicate job is created; contains duplicate key for the job.
- Row gets deleted when job completes OR when duplicate key deletion timeout expires(if it is specified).

* Global table
- Used if the job object method for global locking are used.
- Row gets inserted when global lock is created(job.globalLock()) and removed when the lock is deleted(job.globalRemove()).
- Row gets updated when the lock is released(job.globalRelease()) or when global data is set(job.globalSet()).

What Data manager tables are used by Job in TIBCO IntegrationManager?