We have a scheduler chain that calls 2 scheduler programs.
The chains are controlled by a scheduler job that has job_type as CHAIN.
My challenge is how to add email notfications on the failure or success of the programs.
I know about this procedure DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION, but this is only applicable to jobs and not programs(i believe).
Is there an alternative way to trigger off emails for scheduler programs please?