Database Administration (MOSC)

MOSC Banner

dbms_scheduler job notification email cannot be sent, ora-01031 error in j000 trace file

edited Mar 5, 2014 9:36AM in Database Administration (MOSC) 5 commentsAnswered

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',

  recipients  =>  '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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center