Hi SS,
first of all, you should SELECT FROM table tbtco, which gives you the job executions, eventually restricting by date. Then, for each record there, call function BP_JOBLOG_READ. This will yield aninternal table. LOOP at this itab and evaluate field MSGTYPE = 'E' or 'A', for example.
This will identify the failed jobs. Finally, call function SO_NEW_DOCUMENT_SEND_API1 to send a mail message with the information that you have found for the failed job.
I hope this helps. Best regards,
Alvaro
