Re: DBMS_SCHEDULER external jobs failing but status of SUCCEEDED?!?!

From: <ive_groups_at_web.de>
Date: 3 Nov 2006 08:51:09 -0800
Message-ID: <1162572669.162691.237210@m73g2000cwd.googlegroups.com>

Hi,

I have a similar question, so I post it here. What does 'SUCCEEDED' in dbms_scheduler mean? I am creating a job, that should fail and it does fail, if it is a job, created by dbms_job, but it runs fine with dbms_scheduler.
(I am running Oracle 10.2.0.1 on Solaris, 64bit)

Here is a demonstration:

SQL*Plus: Release 10.2.0.1.0 - Production on Fr Nov 3 17:24:20 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Verbunden mit:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options

SQL> create or replace procedure prc_test_1 is -- eine Procedure, die Fehler raist
  2 begin
  3 raise no_data_found;
  4 end;
  5 /

Prozedur wurde erstellt.

SQL> declare
  2 job number;
  3 begin
  4 dbms_job.submit(job,'begin prc_test_1; end;');   5 commit;
  6 end;
  7 /

PL/SQL-Prozedur erfolgreich abgeschlossen.

SQL> set serveroutput on
SQL> select what, failures from dba_jobs where what='begin prc_test_1; end;';

WHAT

---

  FAILURES

---

begin prc_test_1; end;

         1

SQL> begin
  2
dbms_scheduler.create_job(job_name=>'TEST_PRC1',job_type=>'PLSQL_BLOCK',job_action
=> 'begin prc_test_1; end;',enabled=>true);
  3 end;
  4 /

PL/SQL-Prozedur erfolgreich abgeschlossen.

SQL> select job_name,status, error# from dba_scheduler_job_run_details where job_name='TEST_PRC1' order by log_date desc   2 /

JOB_NAME

---

STATUS                             ERROR#
------------------------------ ----------
TEST_PRC1
SUCCEEDED                               0

Thank you and regards
Elena Ivanova Received on Fri Nov 03 2006 - 10:51:09 CST