HOW TO MIGRATE JOBS PRESERVING LOOKBACK STARTING CONDITION?
We are migrating over 72K jobs from one AutoSys instance to another. Hundreds of these jobs have complex starting conditions, including lookback.
The target AutoSys instance is very active and is therefore not suitable for a database export/import migration. Our current migration method is:
- Insert all jobs nested in a migration-box that is ON_HOLD
- At time of cutover, query source AutoSys instance for job status and use sendevent in the target AutoSys instance to sync the job status
- Move all jobs out of the migration-box
The problem with this method is the job status time gives a positive for the lookback condition, causing job to run out-of-order
- JIL "status:" attribute will set the ujo_job_status.status_time=time jobs inserted into the database
- sendevent -E "mm/dd/yyyy HH:MM" where the datestamp<now will process the sendevent immediately. ujo_job_status.status_time=time sendevent processed
- Broadcom has stated that they do not support manual/sql update of the database.
Can anyone recommend a method to setting the job status where the lookback condition will still be honored?
------------------------------
Roz Smith
------------------------------