We are moving some Oracle overnight jobs off a cron server and running them via Oracle DBMS Scheduler instead. It is my understanding that if the database fails overnight then the job email notification will also fail.
Has anyone got a method of emailing users to let them know their specific overnight jobs failed in this instance (without letting them know the entire database dropped)? It seems a slight limitation of using dbms scheduler over a cron server.
I was thinking if there was a way to monitor a gmail mailbox and if a job success email from the scheduler is not received to then send a job fail message to the users? Couldn't see a way to do this either unfortunately.
Does anyone have any ideas for this scenario? Thanks very much.