my $SQL = "UPDATE kcrei_batch_job_history SET
                            rows_added = $_[1],
                            status = 'C',
                            stop_datetime = getdate(),
                            stop_tran_seq_nbr = $hdr_tran_seq_nbr,
                            elapsed_time_hh = datediff(hh, convert(datetime,$loader_start_time), getdate())
                           elapsed_time_mm = datediff(mi, convert(datetime,$loader_start_time), getdate()),
                            elapsed_time_ss = datediff(ss, convert(datetime,$loader_start_time), getdate())
                        WHERE
                            master_job_no = $master_job_no AND
                            master_job_sub_no = $_[0]";