View oracle DBMS task log

Question

I have a task for a task in a DBMS (not a DBMS scheduler). I see that the work failed on the weekend. I want to see the log file with an error. Where can i find this?

Any suggestions please?

Thanks in advance.

Answer 1

For DBMS_SCHEDULER (as Frank Schmitt noted) try the following:

SELECT *
FROM DBA_SCHEDULER_JOB_RUN_DETAILS
ORDER BY LOG_DATE DESC;

and then look in the bdump folder for the trace files.

For DBMS_JOB, you can view the warning log file:

SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'background_dump_dest';

or

SELECT VALUE
FROM V$SPPARAMETER
WHERE NAME = 'background_dump_dest';

The alert log file has a name like "alert_orcl.log" if your database name is "orcl" by default.

Answer 2

DBMS_JOB . .