<div>
<div class="content wysiwyg-content">
In my Oracle 11gR2 database I set email notification for a Scheduled job. The job is quite simple and it insers records from one schema to another with some Oracle merge statement.<br />
<br />
In the notification email I see the details. How do I interpret its contents? The job it say succeeded but it as well say that Failure count: 7 , what does it actually mean?<br />
<br />
Job: MY_ACCOUNT.MY_ETL_JOB<br />
Event: JOB_SUCCEEDED<br />
Date: 01-APR-11 09.00.05.439087 AM CST6CDT<br />
Log id: 15984<br />
Job class: DEFAULT_JOB_CLASS<br />
Run count: 24 <br />
Failure count: 7 <br />
Retry count: 0 
</div>
</div>


In my Oracle 11gR2 database I set email notification for a Scheduled job. The job is quite simple and it insers records from one schema to another with some Oracle merge statement.

In the notification email I see the details. How do I interpret its contents? The job it say succeeded but it as well say that Failure count: 7 , what does it actually mean?

Job: MY_ACCOUNT.MY_ETL_JOB
Event: JOB_SUCCEEDED
Date: 01-APR-11 09.00.05.439087 AM CST6CDT
Log id: 15984
Job class: DEFAULT_JOB_CLASS
Run count: 24 
Failure count: 7 
Retry count: 0 

Oracle 11g database Scheduled job email notification message

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.