I was trying to manually fail a running job (to simulate a vm failure), and then restart it.
Going by the official documentation, I tried to set the status to FAILED, however I could not get it to work.
Following that, I posted the following question, and found out that I also need to set the endTime and repeat for the batch_step_execution table.
I'm raising this issue for including that information in the official documentation.