Hi all,
I am working on Oracle 11.2.0.3.
I would like to create a Oracle job. Can you please suggest.
below is the requirement.
1. Need t Send in email every 30 minutes from 11 am to 3:00 PM. E-mail should only be sent ONLY when below Query have data return.
select sup_nbr, count(*) , total_qty , LISTAGG(shr_trans_qty, ',') WITHIN GROUP (ORDER BY upd_last_tmstp ) ind_qty
from SALE_TRANS@EMP_SALS where trunc(transaction_dt) = '16-AUG-17' and debt_cd='J' and branch_cd='304'
group by sup_nbr,total_qty;
2 Email Format :
To: <Group 1>,<Member1>, <Group 3>
From: TEAM1,TEAM3
Email Subject: Notice1
Email content: <data return from above query>