title: Why DBMS_Scheduler job failed?
body: <p>I have written one procedure and one job.
  From job I am running procedure. Following is the script for creating job</p>
  
  <pre><code>DBMS_SCHEDULER.create_job  (job_name  =&gt; 'IBPROD2.RUN_FETCH_ACCT_ALERTS',
  job_type        =&gt; 'STORED_PROCEDURE',
  job_action      =&gt; 'FETCH_ACCT_ALERTS',
  start_date      =&gt; sysdate,
  repeat_interval =&gt; 'FREQ=HOURLY;INTERVAL=2;',
  enabled         =&gt; TRUE,
  auto_drop       =&gt; FALSE
  );
  </code></pre>
  
  <p>After creating job I am running following command to get job details for owner IBPROD2 where I can see failure_count column value as 1 for RUN_FETCH_ACCT_ALERTS job.
  There is no problem in procedure FETCH_ACCT_ALERTS when I run it manually.</p>
  
  <p>Can anyone help me in why the job is failing? Am I missing something?</p>