Problem regarding Restarting job with -Restart option

[PragnyaC]

Hi,

We have implemented batch jobs which schdule to run daily on client side. Recently we faced one issue, one job gots failed. We fixed issue and tried to restart it with -RESTART option (instead of -next) to restart job from failed step. But it picked up some old job instance id from batch database to restart job instead of picking up latest failed job.

Can anyone help me to know which job id gets picked up when we restart job using -Restart option.

As per my understanding below are the status in batch_job_execution table.
STOPPING , UNKNOWN , FAILED , ABANDONED , STARTING , COMPLETED , STOPPED , STARTED

Job that failed was haivng FAILED status but when i restarted job it picked up old job with status = STARTED.

Please let me know in which order STATUS gets picked up while restarting job. And also let me know is EXIT CODE status gets checked while restarting?

Thanks in advance !!

[PragnyaC]

Can anyone help me to solve this ?