from my application, I call a Oracle background job and Pl/SQL API. when client invoke Background job or PL/SAL API, I store that start time, end time in my own table. if someone log in to the database and kill that database session, I am not able to store the end time. because, I update the end time when only background job finish. if someone kill the session, end time left blank. then it looks like still running the job. based on the end time I do more calculation.
how should I handle this situation, when someone kill the session, how should I update the end time?