Trouble assigning job & subjob ID’s

The JOBID and SUBJOBID fields are integer fields which means that the maximum number that can be entered into these fields is: 2,147,483,647

This is a constraint of the type of field. This simply means that the last 4 spaces will be taken up with the SUBJOBID component. This leaves the first six digits to be used for a JOBID.

If you were proposing to use a JOBID that was something like 2011555, there would not be space for it as it is seven digits.

Job

If you are having problems with the system automatically assigning the next JOB ID, then there is probably an issue with the NEXTJOBID and the UNUSEDJOBID.

Please run the following scripts:

SELECT NEXTJOBID
FROM ENPRISE_JOBCOST_SETUP

SELECT *
FROM ENPRISE_JOBCOST_UNUSEDJOBID

If there is a value in the UNUSEDJOBID field, then Eralis Job will want to assign this as the next JOB ID. If this is not the next JOBID that you want to use, we would suggest removing this value so the table is blank.

Eralis Job will then use the NEXTJOBID available from the ENPRISE_JOBCOST_SETUP table.

Subjob

If you are having problems with the system automatically assigning the next SUBJOB ID, then there is probably an issue with the NEXTSUBJOBID and the UNUSEDSUBJOBID.

Please run the following scripts:

SELECT NEXTSUBJOBID
FROM ENPRISE_JOBCOST_SETUP

SELECT *
FROM ENPRISE_JOBCOST_UNUSEDSUBJOBID

If there is a value in the UNUSEDJOBID field, then Eralis Job will want to assign this as the next SUBJOBID. If this is not the next SUBJOBID that you want to use, we suggest removing this value so the table is blank.

Eralis Job will then use the NEXTSUBJOBID available from the ENPRISE_JOBCOST_SETUP table.