Creating a custom column in the Job Monitor

You can define a custom column in the Job Monitor by adding a column in a Datacap Engine database table.

About this task

To create a custom column in the Job Monitor, you must add a column in the tmBatch table of the Datacap Engine database. The column name must be preceded by pb_, such as pb_allowed. Configure the data type for MSSQL as nvarchar, for Oracle the data type is nvarchar2, and the data type for Access is text.

You can use Microsoft Access to define a custom column in a development environment but Access is not supported for group filtering because it cannot perform the necessary query for additive groups.

1. In the tmBatch table in the Datacap Engine database, add a column with the name preceded by pb_, such as pb_allowed.
2. Save the table and restart the Datacap server.
3. For SQL only, you must re-create the JobMonitor view by following this procedure.
   1. Open the JMView view for design.
   2. Delete each item that appears in the Alias column.
   3. Press the Exclamation Mark icon.
   4. Save the view.
   5. Open the JobMonitor view for design.
   6. Delete each item that appears in the Alias column.
   7. Press the Exclamation Mark icon.
   8. Save the view.