Schedule Database Task Logs

Hello,

We are converting Database Processes to Scheduled database Tasks, IFS8.

I have few tasks that checks batch log and send emails accordingly, when i created in schedule database tasks, its sending same info again and again… how do i check the logs in Database Tasks or in Background Jobs , if any to accomplish this task.

the query to modify is following, or any other way to achieve same result

SELECT lag(actual_start_date,1) over (order by actual_start_date) last_date
   FROM batch_job bj, batch_job_log bjl
   WHERE action = 'Temporay_API.Generate_Report'
   and bj.job_id = bjl.job_id
   and bjl.status = 'SUCCEEDED'
   order by actual_start_date desc;

Thanks.