Issue with Auto increment in MYSQL
The CREATE TABLE documentation says much the same as what your error message says:


  There can be only one AUTO_INCREMENT column per table, it must be
  indexed, and it cannot have a DEFAULT value.


You need to index the JOB_ID column.

ALTER TABLE JOB_ONPREM
ADD INDEX `dba269102` (`JOB_ID`)


Try that and see if afterwards you can alter the primary key. You could also make it a unique index instead, to help avoid duplicates.

ALTER TABLE JOB_ONPREM
ADD UNIQUE INDEX `dba269102` (`JOB_ID`)