dbms_scheduler job notification email cannot be sent, ora-01031 error in j000 trace file
hi there,
I recently created a job in an app user schema by logging as SYS user, and I added an notification as below:
DBMS_SCHEDULER.add_job_email_notification (
job_name => 'job_name',
sender => 'xx@xx.com',
events => 'job_failed');
Now the problem is, whenver the job got run, I saw a trace file generated for the J000 process:
Error in PLSQL notification of msgid:F328D1166D0D3B42E043E9CD67C1D006
Queue :"SYS"."SCHEDULER$_EVENT_QUEUE"
Consumer Name :SCHED$_AGT2$_523
PLSQL function :SYS.SCHEDULER$_JOB_EVENT_HANDLER
: Exception Occured, Error msg: