Hello,
I am trying to use the Scheduled → Job Navigation to schedule a Stored Procedure run and based on a certain status sending out email notification to recipient.
I am simply using the Job Wizard and post entering the required details, post I am entering the details for Notification like Recepient email address, from email address and other details like Subject, Body, event as - Job Succeded. Post clicking on Apply button I am getting the below error
Failed to process SQL command
- ORA-24035: AQ agent SCHED$_AGT2$_161 is not a subscriber for queue SYS.SCHEDULER$_EVENT_QUEUE
ORA-06512: at "SYS.DBMS_ISCHED", line 7603
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 10514
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 10129
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 10398
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 2155
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 10376
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 10113
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 10485
ORA-06512: at "SYS.DBMS_AQADM", line 921
ORA-06512: at "SYS.DBMS_ISCHED", line 7584
ORA-06512: at "SYS.DBMS_SCHEDULER", line 4620
ORA-06512: at line 3
In the other notes in the community I found email address were advised to be added as +<emailtome@gmail.com>+. I did the same but still the same error. By looking at the error message something relating to schedule, I did a review of the same again and again but couldn't find any issue with the same.
Can some one kindly help on what might be getting missed here.