bootneck2222
asked on
PL/SQL Developer job failure
Hi,
Is there a way to get notification that a job has failures, by email for example? I am using an Oracle 10g database and PL/SQL Developer 7.1.4. I have job that runs daily to import data. Normally I would expect the Failures=0 when viewing the job. If a line of data in the import is in the wrong format, I would expect a failure and the failures to be incremented. I'm after a quick and easy way of identifying if the failure is > 0 without having to go into PL/SQL. Does this figure get stored somewhere in a table? Can it be queried? I'm not an Oracle DBA, so please be gentle.
Thank you
Is there a way to get notification that a job has failures, by email for example? I am using an Oracle 10g database and PL/SQL Developer 7.1.4. I have job that runs daily to import data. Normally I would expect the Failures=0 when viewing the job. If a line of data in the import is in the wrong format, I would expect a failure and the failures to be incremented. I'm after a quick and easy way of identifying if the failure is > 0 without having to go into PL/SQL. Does this figure get stored somewhere in a table? Can it be queried? I'm not an Oracle DBA, so please be gentle.
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What happens in your procedure when a row of data fails to load? Does it log that somewhere and continue on, or does the procedure terminate abnormally with an error?
If the procedure is logging errors and continues on then the failures for the job will be 0. The procedure completed successfully, so it did not fail.
The failures reporting of a job is how many times (in a row) the job terminated with error. It has nothing to do with what the procedure is doing.
If the procedure is logging errors and continues on then the failures for the job will be 0. The procedure completed successfully, so it did not fail.
The failures reporting of a job is how many times (in a row) the job terminated with error. It has nothing to do with what the procedure is doing.
ASKER
Thank you.
Using the DBMS_SCHEDULER, there should be no problem in getting (email) alerts whenever a job fails to succeed. On the other hand, if you're using DBMS_JOBs, then you probably have to write your own monitor/heartbeat job/process which in turn watches over all the other jobs running on your system....