How to update Large table in MYSQL
If the job_no is unique it could be much faster (adding a unique index to the job_no). but even if its not unique this query could be optimized just adding an index to the job_no

ALTER TABLE jobs
ADD INDEX ind_job_no (job_no) USING BTREE;

adding this index will allow you to update quicker.