Hi Jason,
else
Is it possible to do like this
untill current session job executes successfully
start loop
waitfor delay '00:00:02'
check the jobstatus of current session
end loop
and the next record excutes procedure and generates report with its values