I got the trace this morning again. The total time from all statements in the stored procedure is about 8 seconds. But the sp:Completed shows the duration is about 1 hour and half, which is the same as in job history.

Should I capture more events maybe?