We have several databases among those a Prod and Test Oracle environment. At one time the Prod database was refreshed into the test database. With that refresh came all the scheduler jobs and notifications. Some job notifications got sent out of Test but appeared as though they were from Prod.
We corrected that issue and recreated all the job notifications in test. We even changed the format of the subject and the message body. The messages also go to different email aliases in test vs prod.
We have notifications set on for when a job is broken. At various times over the past several months, the job has broken and we receive the new job notifications. Only we are also receiving the old notifications labeled as being from Prod.
So, we have 2 sets of emails going out to 2 different aliases, and one of them is from a set of notifications that no longer exist. I have checked dba_scheduler_notifications. I have google searched numerous times and checked various other various system tables. No notifications exist for any jobs in the old Prod format sending to the Prod email alias. Yet the emails persist.
I have dropped and recreated the job several times. I recently discovered there was an additional job owned by SYS with the same name. There were no notifications associated with this job, but I deleted it anyway. No change in the problem.
I actually thought there could have been a duplicate instance. I was assured by the DBA this is not the case.
I have tried many different things. Nothing stops those messages.
Does anyone have any ideas?