i am wondering:
if you need to condition the job therefore it is changed in the game correct?
if not just work as you setted it in the db
if i am right, after the change make a variable operation
(1 = warrior, 2 = something else 3= mage, like their position in the database)
then you can conditional "if variable(jobs) = 3 then"
and that will solve everything