Before I get my hands dirty
I regularly backup the fme_job_history table for analysis. When I upgrade FME Server I'd like the job_id to remain consecutive instead of restarting from 1.
Is there a way to set the starting job_id after a re-install?
In SQL Server fme_job_history.job_id is not an identity column and I cannot see any hint in sqlserver_createDB.sql